Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Couple of Macro Questions
I would like a macro to automatically run if the date is
anywhere in a given 8 week period. For example, if the date is greater then October 1, I would like the macro to run and I only want it to run once. The code I have put in place is: If Date=October1 then Sheets("FORECAST").Select Range("AA8:AA44").Select Selection.Copy Range("Z8:Z44").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("A1:A3").Select Application.CutCopyMode = False Else End Can someone review and let me know if this is right. Also, how do I only get it to run once? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
couple of questions | Excel Discussion (Misc queries) | |||
A couple of questions | Excel Discussion (Misc queries) | |||
Couple of Questions | Excel Discussion (Misc queries) | |||
A couple of questions... | Excel Discussion (Misc queries) | |||
Couple more questions... | New Users to Excel |