Macro

H

Homero

hi there,

i want that a macro select the first cell empty in a row, how can i do that?

can anyhone help me?
 
T

tjtjjtjt

Any particular row?
For a nonmacro way, if the row is selected. Press Home on the keyboard. Then
press Ctrl+Right Arrow. This will select the first cell in the row. If it's
blank, you're done. If it's not blank, press Ctrl+Right Arrow followed by the
right arrow.

One macro option, if the row in question contains the active cell:

Sub FBlank()
Dim r As Range
Set r = Range("A" & ActiveCell.Row)
Do Until r = ""
Set r = r.Offset(0, 1)
Loop
r.Select
End Sub
 
Top