| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Formula
I don't think there is an inbuilt function to find it exactly so I've
used a combination to get the result of the sheet name: =RIGHT(CELL("filename"), LEN(CELL("filename"))-FIND("]",CELL("filename"))) Hope this helps. FunkySquid Rob wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Formula
FS,
Just to make certain I understand correctly... "filename" should be the name of the workbook and "CELL" should be the cell that I'm getting the info from; my example below... =RIGHT(A130("ItmHndl.xls"), LEN(A130("ItmHndl.xls"))-FIND("]",A130("ItmHndl.xls"))) Thanks for your help, Rob "FunkySquid" wrote: I don't think there is an inbuilt function to find it exactly so I've used a combination to get the result of the sheet name: =RIGHT(CELL("filename"), LEN(CELL("filename"))-FIND("]",CELL("filename"))) Hope this helps. FunkySquid Rob wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Formula
Nope.
Just try the original suggestion. Rob wrote: FS, Just to make certain I understand correctly... "filename" should be the name of the workbook and "CELL" should be the cell that I'm getting the info from; my example below... =RIGHT(A130("ItmHndl.xls"), LEN(A130("ItmHndl.xls"))-FIND("]",A130("ItmHndl.xls"))) Thanks for your help, Rob "FunkySquid" wrote: I don't think there is an inbuilt function to find it exactly so I've used a combination to get the result of the sheet name: =RIGHT(CELL("filename"), LEN(CELL("filename"))-FIND("]",CELL("filename"))) Hope this helps. FunkySquid Rob wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Formula
OK, so how do I incorporate this code....
=RIGHT(CELL("filename"), LEN(CELL("filename"))-FIND("]",CELL("filename"))) into or with this code.... =IF(INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) & "'!A70")<FALSE,INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) & "'!A70"),"") Because if I just copy/paste it it doesn't seem to work. So I am wondering where I use the suggested code? Thanks Much. Rob "Dave Peterson" wrote: Nope. Just try the original suggestion. Rob wrote: FS, Just to make certain I understand correctly... "filename" should be the name of the workbook and "CELL" should be the cell that I'm getting the info from; my example below... =RIGHT(A130("ItmHndl.xls"), LEN(A130("ItmHndl.xls"))-FIND("]",A130("ItmHndl.xls"))) Thanks for your help, Rob "FunkySquid" wrote: I don't think there is an inbuilt function to find it exactly so I've used a combination to get the result of the sheet name: =RIGHT(CELL("filename"), LEN(CELL("filename"))-FIND("]",CELL("filename"))) Hope this helps. FunkySquid Rob wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
