Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula in code
hi,
i have the following: Dim CurrentReportMonth As Date CurrentReportMonth = "=DATE(YEAR(NOW()),MONTH(NOW())-1+0,1)" i am trying to figure out how i can make this work, like setting the currentreportmonth in code, but i keep getting the error message. what am i doing wrong? thanks in advance, geebee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using formula in code | Excel Programming | |||
formula or vba code | Excel Programming | |||
Help with Formula in Code | Excel Programming | |||
Add formula in the code | Excel Programming | |||
formula to code help | Excel Programming |