| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Formula
I was wondering if it's possible to modify this formula to make it load the
current active sheet instead of the current "month-day" like the way I have it right now? =IF(INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) & "'!A130")<FALSE,INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) & "'!A130"),"") Is there a method like the VBA "ActiveSheet" for cell formulea? Thanks In Advance, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
| how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| How does Data Validation change with a formula change? | Excel Worksheet Functions | |||
Threaded Mode
