G
Guest
Hi!
When I try to write this command in a macro :
sheets("S1").range("A5:E5).copy (sheets("S2").range("A10:E20"))
occurs an Error "Run-time error '1004': Impossible to execute the copy
method in range class". It seems to me the copy command only works well when
target sheet is the current sheet, I think... (It works when I try to copy to
the sheet where the code is executed)
Is there a way to do this? I need to copy the value and the format os the
cells in the range...
Thanks
When I try to write this command in a macro :
sheets("S1").range("A5:E5).copy (sheets("S2").range("A10:E20"))
occurs an Error "Run-time error '1004': Impossible to execute the copy
method in range class". It seems to me the copy command only works well when
target sheet is the current sheet, I think... (It works when I try to copy to
the sheet where the code is executed)
Is there a way to do this? I need to copy the value and the format os the
cells in the range...
Thanks