| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last row with data in a column
I am trying to improve my macro.
At the moment I have data in column A. It always starts in cell A1 and I need to find the last row with data. At the moment I have the following code: Cells(1, 1).Select Selection.End(xlDown).Select EndCell = ActiveCell.Row I am trying to get away from actually selecting cells in a sheet if I can. Is there some code that will find the last row for me? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Last row with data in a column
lastcell=cells(rows.count,1).end(xlup).row
-- Don Guillett SalesAid Software "fullers" wrote in message ... I am trying to improve my macro. At the moment I have data in column A. It always starts in cell A1 and I need to find the last row with data. At the moment I have the following code: Cells(1, 1).Select Selection.End(xlDown).Select EndCell = ActiveCell.Row I am trying to get away from actually selecting cells in a sheet if I can. Is there some code that will find the last row for me? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Last row with data in a column
Thanks very much Don.
"Don Guillett" wrote: lastcell=cells(rows.count,1).end(xlup).row -- Don Guillett SalesAid Software "fullers" wrote in message ... I am trying to improve my macro. At the moment I have data in column A. It always starts in cell A1 and I need to find the last row with data. At the moment I have the following code: Cells(1, 1).Select Selection.End(xlDown).Select EndCell = ActiveCell.Row I am trying to get away from actually selecting cells in a sheet if I can. Is there some code that will find the last row for me? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort data in column B to align with data in column A? | New Users to Excel | |||
| 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) | |||
| counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
| find data in one column and use data in the next column over Exce | Excel Programming | |||
Hybrid Mode
