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