Z
Zilla
In VBA..
Is it possible to set a Range object to skip empty cels? IOW, if I
copy A1:A10, and A5 is empty, and transpose them on B20, I want to
skip A5; I did SkipBlanks:=True and it still pasted the blank cells.
Incidentally, doing it via Paste Special wizard, and checking skip
blank cells produces the same result.
Is it possible to set a Range object to skip empty cels? IOW, if I
copy A1:A10, and A5 is empty, and transpose them on B20, I want to
skip A5; I did SkipBlanks:=True and it still pasted the blank cells.
Incidentally, doing it via Paste Special wizard, and checking skip
blank cells produces the same result.