Well the code worked but when I went to look at my numbers today, they all shifted along with the first page. So instead of it being A1 when I inserted the new row, the second page is now referencing A2.
from second sheet
=Current!$A$1
After inserting a row on the first sheet this is what the second sheet reads
=Current!$A$2
Any more ideas?
Maybe
VBA Noob=INDIRECT("Current!A"&ROW(A1))
_________________________________________
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 !!!
Works perfect so far, thanks a ton!
Your welcome
Could also try
VBA Noob
=OFFSET(INDIRECT("Current!A1"),ROW(A1)-1,COLUMN(A1)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks