Skip specific column of VBA array

[ImranBhatti]

Hi

I have a 5 column and 20 rows VBA array in memory

What I want is to print the array on the sheet but skipping the 3rd column of the array

means if I print the full array on the sheet , the range address will be
Range("A1:E20")

While I want to print by skipping its 3rd column and the address on sheet should be

Range("A1:D20")

[shg]

You could write the entire array then delete the cells containing the third column.

[YasserKhalil]

Try this line

Please Login or Register  to view this content.

[ImranBhatti]

@sir shg
I have a very narrow space and from the A21 some other data starts. so can't do that

[ImranBhatti]

Thanks YasserKhlil

It works. Just had to transpose it

[YasserKhalil]

You're welcome. Glad I can offer some help