MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding first and last cells containing data


Posted by Jerry Weinstein on June 06, 2001 9:55 AM

How can I (keystrokes or VBA)
1. Find the first cell after column x in a row that has data
2. Find the last cell in a row after column x that has data

I want to write a macro that will do this for large file but I'm sure of the above technique.

Thanks.


Posted by Dave on June 06, 2001 10:39 AM


Not really sure what you need since your explanation can be interpreted in different ways. But try this :-

(1)
If Cells(1, x + 1) <> "" Then
Cells(1, x + 1).Select
Else
Cells(1, x + 1).End(xlDown).Select
End If
End Sub

(2)
Cells(65536, x + 1).End(xlUp).Select