In VBA can one refer to a relative cell, as opposed to an absolute. In other words, instead of specifying , say A1, you specify A1 modified by the value in cell V1, which may be 5, aking the required cell A6.
In VBA can one refer to a relative cell, as opposed to an absolute. In other words, instead of specifying , say A1, you specify A1 modified by the value in cell V1, which may be 5, aking the required cell A6.
Last edited by jackson7249; 11-25-2010 at 09:09 AM. Reason: Invalid request
Hmmm... if you had a 5 in cell V1 and wanted to get to A6 you could use something like this in your vba code...
Not sure that's truly "relative" though, as we've hard coded the reference to cell V1. Depending on the charaters of that specific cell (like it's the last used column, first row), more flexible code can be used....Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks