Alternative vba code

[pezalmendra]

Hello!

Could someone help me in modifying the bellow code into a similar one?
There is something I must be doing wrong cause is not running properly...

Please Login or Register  to view this content.

Thank you very much.

Kind regards,

pezal

[AB33]

Why can not you use a normal cell-range?

If Sheet20.Cells(3, 2 + 14 * i) = "" Then

is row 3, column 16 times I, if I =1, you are looking at row3 column 16.
If you are trying to copy an entire column

Use

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

[AB33]

Why can not you use a normal cell-range?

If Sheet20.Cells(3, 2 + 14 * i) = "" Then

is row 3, column 16 times I, if I =1, you are looking at row3 column 16.
If you are trying to copy an entire column

Use

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

[pezalmendra]

OK! Thanks!

Regards