| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop through rows evaluating 2 cells
If you went to the bottom of the worksheet (or any cell past you data ) and
selected a cell, then hit the END key , then the Up Arrow, the selection would move to the last cell in that column containing data or a formula. That is what the code does - finds the last cell in the column containing data or a formula and returning the row number of that cell. -- Regards, Tom Ogilvy "mthomas" wrote in message ... Tom, Thanks for the reply and it works! But could you please explain what this line is doing.... lastrow = cells(rows.count,1).End(xlup).row Thanks again for you help on this and have a great day! -- mthomas ------------------------------------------------------------------------ mthomas's Profile: http://www.excelforum.com/member.php...o&userid=25649 View this thread: http://www.excelforum.com/showthread...hreadid=390580 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Evaluating a group of cells | Excel Discussion (Misc queries) | |||
| evaluating text of cells | Excel Discussion (Misc queries) | |||
| Evaluating Empty Cells | Excel Programming | |||
| Evaluating Empty Cells | Excel Programming | |||
| Loop cells - get all rows with matching data - paste into different wb | Excel Programming | |||
Threaded Mode
