Copy Formatting from one row to another using VBA

  • Thread starter Thread starter louisamarkham
  • Start date Start date
L

louisamarkham

I need to copy all formatting from one row, example cells A14:L14 to
A15:L15.

I am writing a macro to add a new entry. It will unprotect the
worksheet then find the last row, then add the new entry in the row. I
will then copy the formatting down from the previous row to it.

Thank you for your help.
Louis Markham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
VBA copy and paste data 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Copy row grouping from one worksheet to another 1
conditional format fails when copied 1
Retrieving Current Row,Columns & copying Format from Row,Columns a 2
Macro to copy all rows between Comments 1
Breaking One Row into Multiple Rows using VBA Macro? 2

Back
Top