Can someone please tell me how to create a line in vba that activates/selects
the last cell with data in the row that I'm in. So if I have a table that
goes from A1 to Z20 and I'm somewhere in row 3 what script do I put in the
macro to get me to Z3. I will be adding a new column of data every month so
next month I'll be adding data to column AA. Then the next month I'll be
adding to AB and so on. Please don't take the impression that it will be row
3 that I'm in every time though. I just need to get to the last cell in the
particular row that I'm in. So if I'm in row 3 I will need to get to the
last cell in row 3 and not the last cell in any other row.