Code Usage Question

[Guest]

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

 

[Bob Phillips]

Why would you want to? If you want to look on this sheet just do =A70

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Well, I have a combobox that gets its list from a range of cells located on a
seperate worksheet and that list is dynamically populated by the current days
worksheet. But I want it to populate from the currently viewed worksheet
instead. The original formula (second one provided below) works but only so
far as the current day.


Thanks for the Attention,
Rob

Why would you want to? If you want to look on this sheet just do =A70

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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