Paste Special - Values, Formats and Column Width Not Working

Dear All,

Am using a cell reference to specify where to paste the results using copy, paste special in the code below.

I am trying to clean up the code and developed 3 methods, 2 that work, but the 3rd does not.

My question is, why does the 3rd method not work, as I have seen this illustrated in various sources online?

Thanks for your help in advance, John.

Please Login or Register  to view this content.

Maybe try something like this ?

Please Login or Register  to view this content.

I don't know why if without "with ... end with" it doesn't work,
but if with "with ... end with" it works

Hello,

I tried your suggestion but that did not work.

Any other thoughts?

Thanks John

I tried a variant of Method 4 and it pasted the values but then gives an error when it comes to pasting the formats.

Please Login or Register  to view this content.

Any other suggestions?

Thanks John

Originally Posted by John Vieren

I tried a variant of Method 4 and it pasted the values
but then gives an error when it comes to pasting the formats.
Any other suggestions?

Thanks John

Sorry, I don't know for other suggestion.
I think I need to see the sample workbook to know what are there in the cells to be copied.

Hi,

The reason i am using [] is because in the sell is a formula that produces the range to paste to, for example A1:B10.

The code pastes the values correctly but fails on pasting the formats.

Meaning that using the brackets is working and something else is the problem.

Thanks John