Thread: goto next if
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default goto next if

Post your code

"Miree" wrote:

I have 8 columns of user entered data which i need to copy into another
worksheet.
I have the code to move it over but not all 8 colums will be filled all the
time and i dont want to copy over blank lines. I want to write code to say if
cell 1 is empty donot copy go to cell 2, then if cell 2 is empty, donot copy
goto cell 3..... and so on.
it may be that random colums have data so i need it to check each one.