LinkBack URL
About LinkBacks
What if instead of the value to be the same you wanted it to ref the other cell like =A1 not the value of A1.
~RUTH~
.value vs link?
What if instead of the value to be the same you wanted it to ref the other cell like =A1 not the value of A1.
~RUTH~
Try this, untested:
Sheets("Tool").Range("D10").Formula = "=" & Sheets("data").Cells.Find("zip").Offset(0, 1).Address
Nope
No that didn't do it. Instead it gave me an =$B$8 as text and also that ref that sheet not the sheet it came from. So even if it wasn't text the formula is wrong.
~RUTH~
As I also say. Post the file and tell us your expected result
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks