fin next empty cell in coloumn a

[khalid79m]

i need a vb scrip that will find the first empty cell in coloum A on sheet 10

[dominicb]

Good evening khalid79m

How about this :

Sub test()
n = Sheets("Sheet10").Range("A65536").End(xlUp).Row
MsgBox n
End Sub

HTH

DominicB

[khalid79m]

Works fine