change of font colour or background colour vba

[KK1234]

Hi all,
I am using this code to copy data to another sheet.

I am trying to modify code in a way that when the data is copied to another sheet, the copied row in range A1 the background colour changes to yellow and font colour to Red

Please Login or Register  to view this content.

Any help please.

kind regards

[KK1234]

Hi all again.
I have tried many options but still it is not working. Please help
Kind regards

[Leith Ross]

Hello KK1234,

You are missing a step in your object reference hierarchy. Both the Color and ColorIndex properties belong to the Interior object.

Please Login or Register  to view this content.

[KK1234]

Hi Leith Ross,
thanks . I was indeed missing a step
However it still goes to debug and the same line is highlighted
I dont know why
I am trying to achieve is that in sheet1, when a row is copied, the column 1 cell gets interior colour yellow
I have attached a sample now
Kind regards

[berlan]

Using the activecell here gives the error. Try this:

Please Login or Register  to view this content.

Another option:

Please Login or Register  to view this content.

[Leith Ross]

Hello KK1234,

Thanks for posting the workbook. This worked for me.

Please Login or Register  to view this content.

[KK1234]

Hi Leith Ross,
Thanks . This one works fine. I understood the details.

Also the option 1 given by berlan is the one works great and currently I am going to use it as it exactly does what I was trying to achieve.
Your solution is also very great and I am going to store it as I will use it at some point in my Learning project ( very big one)

I have clicked * to thank both of you for your help.
Kind regards

[KK1234]

PS: It does not allow me to click star for 'berlan' again as I have just done it in another question.
Actually 'belron' deserves more *
Here are from me for 'berlan's great, perfect & prompt help / solution

Kind regards