Copy/Paste a row with a variable range

  • Hi everyone,
    I am stuck with a piece of code and would really need your help on this. I want my macro to copy the format of a the whole row from a variable range and paste this format to a an other row. However y code does not work on this and I can't find why. Below is the code I used (this is just a part of it, I just put the code that was not working).
    I think I do not use the row property properly but I am not sure. Could you please help me on this ?
    Thank you :)

  • You want to use the EntireRow to get the range selected, not the Row property.

    Best Regards,
    Luke M
    "A little knowledge is a dangerous thing."

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!