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

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)

"Rob" wrote in message
...
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

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

"Bob Phillips" wrote:

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)

"Rob" wrote in message
...
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