for x 2 to 100
 

hi, I basically want to add an if statment to move to the next X if a cell is
empty else conitun, please help.

For x 2 to 100
If isempty(range("H" & X)) then
***go to next x
else
perform what I want
end if
next x
--
Thank you...

for x 2 to 100
 

Something like this perhaps: HTH Otto
Sub Test()
Dim x As Long
For x = 2 To 100
If Not IsEmpty(Range("H" & x)) Then
'perform what I want
End If
Next x
End Sub

"EXCELMACROS" wrote in message
...
hi, I basically want to add an if statment to move to the next X if a cell
is
empty else conitun, please help.

For x 2 to 100
If isempty(range("H" & X)) then
***go to next x
else
perform what I want
end if
next x
--
Thank you...

for x 2 to 100
 

Try it like this...

For X = 2 To 100
If Range("H" & X).Value = "" Then
'perform what I want
End If
Next

or this (more efficient method)...

For X = 2 To 100
If Len(Range("H" & X).Value) Then
'perform what I want
End If
Next

--
Rick (MVP - Excel)


"EXCELMACROS" wrote in message
...
hi, I basically want to add an if statment to move to the next X if a cell
is
empty else conitun, please help.

For x 2 to 100
If isempty(range("H" & X)) then
***go to next x
else
perform what I want
end if
next x
--
Thank you...