Diane has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Excel VBA Advanced course
Syntax question
Hi, How could I modify this code to maintain the format of the source cell? I know I could change the whay I do it, but if I can modify this simple statement I would rather.
Thanks
Range(sCopyFromRange).Copy _
Destination:=Range(sCopyToRange)
RE: Syntax question
Hi Diane,
I think this already does this.
I've just checked with this line and it keeps the formatting applied to A1.
Range("A1").Copy Range("A2")
Does this do what you need?
Let me know if I've misunderstood.
Claire
RE: Syntax question
Hi Claire
No, it isn't taking my formatting across, but I think you are right it should be. I have a cell colour on my source but the cell after copy on the target remains default no colour.
Thanks
Diane
RE: Syntax question
Hi Diane,
Sorry to hear it's not behaving as expected.
Please let us know if you have any further questions.
Claire
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.