Thread: for x 2 to 100
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EXCELMACROS EXCELMACROS is offline
external usenet poster
 
Posts: 43
Default 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...