want to advanced to cell on the right but my code won't work
 

Hi

What my macro should do is move to the next cell to the right when the
current cell is occuiped.

sample of my data
A1 A2
C1

want to advanced to cell on the right but my code won't work
 

If ActiveCell.Value < "" Then
Activecell.Offset(0,1).Select
End If

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
ups.com...
Hi

What my macro should do is move to the next cell to the right when the
current cell is occuiped.

sample of my data
A1 A2
C1

want to advanced to cell on the right but my code won't work
 

On Apr 16, 6:04 pm, "Bob Phillips" wrote:
If ActiveCell.Value < "" Then
Activecell.Offset(0,1).Select
End If

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message

ups.com...



Hi

What my macro should do is move to the next cell to the right when the
current cell is occuiped.

sample of my data
A1 A2
C1- Hide quoted text -

- Show quoted text -

Thank you for your fast reply, but this is not what i was looking for
also
i din get to finish typing the message,
i have recreated a new post
http://groups.google.com/group/micro...917c0de07bf77a
Maybe you can provide my pointers on why i can't get my code to work.

Thank you
kiwis