Previous Topic Next Topic

Excel 2007 VBA Find Last

Solved/Closed
Tjones4852 Posts 11 Registration date Monday 10 May 2010 Status Member Last seen 9 December 2011 - 10 May 2010 à 16:48
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 10 May 2010 à 18:26
I have a mutipage workbook where I am coping information from three sheets and consolidating the information to another sheet so I can export into a csv file. Some of the rows in the individual sheets may be blank when they are copied and must remain so on the base sheet.

Once I get all the data on the consolidation sheet I remove all the blank rows.

My problem is when I go to paste the data to my consolidation sheet I need to select the next empty cell in column A and some of the values in A may be null or 0. So I am attempting to look from the bottom up instead of the top down.

All the data is variable in length.
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
10 May 2010 à 18:26
If col A always has some data you can use this

lMaxRows = Cells(Rows.Count, "A").end(xlUp).row

Similar discussions

How to invoke VLookUp function in Excel VBA.
Wingie -
TrowaD -

1 response