LinkBack URL
About LinkBacks
I didn't read the line above - you can't assign a range based on a formula like that. Best guess would be:
Set TopCell = sheets("Data Tab").Range("A2").Offset(0, Range("B16").Value - 1).Resize(Range("B1:B15").cells(Range("B16").Value,1), 1)
I didn't read the line above - you can't assign a range based on a formula like that. Best guess would be:
Set TopCell = sheets("Data Tab").Range("A2").Offset(0, Range("B16").Value - 1).Resize(Range("B1:B15").cells(Range("B16").Value,1), 1)
Everyone who confuses correlation and causation ends up dead.
Wow, Thank you so much Romperstomper.. It is working super cool
Last edited by romperstomper; 12-06-2011 at 05:29 AM. Reason: remove unnecessary quote
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks