Paste inserting blank cells

danparaianu - Oct 10, 2011 at 07:14 AM
 Blocked Profile - Oct 11, 2011 at 12:09 AM
Using VBA I want to copy a column with a variable length and paste into another column inserting 2 blank cells for every value pasted, like that:
Column1 Column2
a a
b Blank
c Blank
d b
e Blank
. Blank
. c
. Blank
. Blank
. d
. .
It is possible that?

1 reply

Blocked Profile
Oct 11, 2011 at 12:09 AM

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.