Copy a range skipping formulas when pasting

[YasserKhalil]

Hello everybody
I have a range in sheet1 range("C9:K10") that have values only..
I want to copy that range to sheet2 to the same range ("C9:K10") skipping the formulas in sheet2
for example in cell E9 in sheet1 I have the value 25 , I need to skip that value during the paste process because the same cell in sheet2 has a formula
Hope it is clear

[YasserKhalil]

Is there a way to skip the cells that have formulas from the paste process?

[YasserKhalil]

Is it possible to do such task or it is unfamiliar?!!

[YasserKhalil]

Is there a solution for that task?

[XLRATOR]

Hello There,
You can try something like this:

Please Login or Register  to view this content.

[YasserKhalil]

But i suppose that the target cells should be mixture of xlCellTypeConstants and xlCellTypeBlanks
How can I combine the two criteria in the your great code?

[AB33]

I do not think this works in multiple selection of columns, but you can try

Please Login or Register  to view this content.

[YasserKhalil]

It doesn't work if I cleared the constants in sheet2 . I mean if they are blanks there is an error message which tells me there is no cells!

[AB33]

How about this

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

Please Login or Register  to view this content.

?

[YasserKhalil]

Mr. AB33
The same error message 1004 : No cells were found !!!

I devised this little trick

Please Login or Register  to view this content.

Any suggestion about this trick?

[AB33]

I did not get an error on

Please Login or Register  to view this content.

I do not think 2, and 4 work on multi column selection. Special cells works on a single column ONLY

[YasserKhalil]

Mr. AB33
Thanks for your interest about this thread
Try to clear the contents of the constants of Sheet2 and run the maco.
The error message will appear

[AB33]

Well as I said on earlier post, special cells does not work with multiple columns. It works with the loop as it is looking through each column (cell in a column) at a time.
Try to select multiple columns with special cells and you will get an error saying that "You can not select multiple"

[YasserKhalil]

Thanks for the information Mr. AB33
How can we overcome this error and get the correct results?

[AB33]

I do not see any other than to loop through each cell.
I do not like to include a line as error trapping, but on column with some cells which are not blank, you can probably put it as resume next if there are no blank cells, the code skips that cell.

[YasserKhalil]

Thas a lot for your help