Hi,

I wrote a macro as practice and in that macro I used the 'UsedRange' to identify the columns and rows being used up by data.

then I used the following syntax to identify any empty columns in between so they can be ignore by the code and the code can move on to the next column.

If Not IsEmpty(Columns(iCol)) Then
What the above code is meant to do is ignore the column no. 'iCol' if its empty. However VBA does not like it and while it doesnt give me any sort of error, it does not bypass the empty column either. What am I doing wrong here?

Also, even though I have read a bit on Integer and Double (& singles), I still am not comfortable with the differences. TO my mind, there would be hardly any use for doubles to be specifed as data type, can anyone shed some light please.

Cheers,