formula doesn't work when copy /pasted.

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I am using the formula pasted below to read the sheet
name. It works on the origonal sheets I made with it but
does not work when I move the worksheet or try to copy the
formula from the working page into the copy (into the same
same cell). I can't figure out why. Can someone help?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)


TIA


Todd
 
I get "Value". I copied several months of the worksheets
on friday. A few worked as a copy and most did not. So
far today I haven't been lucky and none work. I tried F9
and that hasn't worked either.

Thank you.



-----Original Message-----
Hi
what does happen (what is the exact error)?
Does hitting F9 help?

--
Regards
Frank Kabel
Frankfurt, Germany

I am using the formula pasted below to read the sheet
name. It works on the origonal sheets I made with it but
does not work when I move the worksheet or try to copy the
formula from the working page into the copy (into the same
same cell). I can't figure out why. Can someone help?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)


TIA


Todd
Click to expand...
.
Click to expand...
 
Its working! Apparently, I didn't have the work sheet
saved. Thought I did.

Thank you very much.


Todd



-----Original Message-----
Hi
what does happen (what is the exact error)?
Does hitting F9 help?

--
Regards
Frank Kabel
Frankfurt, Germany

I am using the formula pasted below to read the sheet
name. It works on the origonal sheets I made with it but
does not work when I move the worksheet or try to copy the
formula from the working page into the copy (into the same
same cell). I can't figure out why. Can someone help?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)


TIA


Todd
Click to expand...
.
Click to expand...
 
Back
Top