Hands

Here is the input: Activity, start week, end week Based on the above info in the the first three columns of a spreadsheet, put a number or a string in the same row under the appropriate week number. So if an activity happens from week 18 (this week) to week 25, the corresponding columns would be filled with the number 1. So far I have not been able to figure out how to do this using macros. Seems pretty simple but I'm struggling since I have zero experience with Visual Basic and objects, methods, prodecures,etc. I can get the desired result using Excel by putting the followiing statement in every column .... =IF(AND(week<=start,week>=stop), 1,""), where week, start, stop are defined ranges. I tried to do the macro record but that doesn't yield a useful stating point

Hands -- Hi! I'm a very seasoned, wireless (LTE) SW test Engineer. I'm trying to learn Macros, and VB for Excel. Having a hell of a time.

I found that if I open Excel 2007 first and then open an existing file from inside excel the problem goes away. Simply clicking on the .xls file to open it, keeps the problem present. I think this may be rooted in the the Original version of Excel the the file was created in or the file may have been saved as an older version of Excel. Would love to hear your feed back on whether this works for you.

I have the same problem but it used to work on a previous version of the file ( when updated, I always do a 'save as'). The other issue is that the 'copy special' has only text options all the other normal options (formula, value, formating, etc.) are not there!