raydogg57 0 Light Poster

I am using the VB editor in Microsoft Excel and have come upon a slight problem. Basically, I wrote a macro that allows me to copy an array of data from one worksheet, and then paste it into another worksheet. (So by using the macro, I can automatically update the sheet without physically copying and pasting the data myself). I have the code perform this task just fine. The only problem is that the sheet I am pasting the data to is an array that is twice as large (the columns remain the same number, however there are twice as many rows because I have spaces between them for further calculation). Is there a line of code I can put in that will allow me to copy the array, but then paste it with spaces in between the rows?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.