selecting columns
Hi,
I have a table, that while writing a vba code I need to select the first column in the table (A) and the last column with data inj the table ( unknown which column it is).
The last column might change (meaning that it sometimes column B, somestimes column Y etc...depends on the data).
I need a way to select only the the first AND the last column in that table(actually it's the last column with data on that sheet).
I'm sure there is must be a way I just don't know it!
thanks
Last edited by Abroza; 09-08-2009 at 02:31 AM.
This will select the the first column down the last used row and the last column down to the same last row.I need a way to select only the the first AND the last column in that table(actually it's the last column with data on that sheet).
Please Login or Register to view this content.
it works,
thanks!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks