any help please.
After finding a blank cell using code below i would like to make that blank cell the active cell.
I know that you cannot assign a constant to a an active cell address therefore the below line of code fails
Public Sub findcell()
ActiveCell.Address = Worksheets("sheet1").Range("e4").End(xlDown).Row + 1
MsgBox "the active cell is " & ActiveCell.Address
End Sub
After finding a blank cell using code below i would like to make that blank cell the active cell.
I know that you cannot assign a constant to a an active cell address therefore the below line of code fails
Public Sub findcell()
ActiveCell.Address = Worksheets("sheet1").Range("e4").End(xlDown).Row + 1
MsgBox "the active cell is " & ActiveCell.Address
End Sub