There are better methods but this old dog is only just learning:On 2002-03-13 16:54, brettvba wrote:
Need Some code to select the next empty cell on a page for example
range("a1").select
'where a2 is the next avaliable cell
then a3 and so on?
Dim MTCell as Range
for each MTcell in Range("a1:A10")
If ActiveCell = Not Empty Then
(do your thing here)
End If
Next
Like this thread? Share it with others