| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last column
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C | Excel Programming | |||
Threaded Mode
