Thread: Paste special using an array

Hi all,

Having troubles with this one. I'm populating an array from one sheet and closing it. Then opening a new sheet and pasting the array into a range.

That all works which is grand. However, I want to use the paste special / Add / Skip Blanks. I want to sum the cells if there is a value already. I don't really want to have to iterate each array element and sum them that way. Here's what I've got:

cellRange = Range("C6:AF48").Value
ActiveWorkbook.Close
Range("C6:AF48").Value = cellRange ' this is where I want to use paste special.

Any ideas as to how I can achieve ths?

All the best,
John

Please edit your post to comply with the Forum Rules.

Rule #3

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.