i want to loop through the A row but i want to skip the cell if there is no value, but when there is a value i want to copy
the values in the corresponding column and save them to another worksheet to the range stated in the active cells value.

this is kind of what I want to do:


Dim lCol As Long

For lCol = 1 To 100

if active cell is empty
do nothing

else

select range of active cell and copy contents of column of cell and paste in sheet 2 in the range of active cells value.

next 1coll.


I know what I want to do, I just cant work out how ):
any help with be grateful