masterkemist
New Member
- Joined
- Feb 1, 2005
- Messages
- 11
I have a relative sheet reference function that returns a string as in
refonprevsheetname("G10")
I understand that it is a string but I want the row number to change as I move down the column. This way I can drag the fill handle down instead of typing each one out. Can anyone offer any solutions?
refonprevsheetname("G10")
I understand that it is a string but I want the row number to change as I move down the column. This way I can drag the fill handle down instead of typing each one out. Can anyone offer any solutions?