This code caused a run time error 1004: paste method of worksheet class failed:
AA58 is actually the leftmost cell of some merged cells; I changed it to the following
and it runs fine.
My question is this: is there a way to paste into the merged cells without selecting them?
Thanks
David
Code:
Range("N1").Copy
ActiveSheet.Paste Destination:=Range("AA58")
Code:
Range("N1").Copy
Range("AA58").Select
ActiveSheet.Paste
My question is this: is there a way to paste into the merged cells without selecting them?
Thanks
David