Copy Formatting from one row to another using VBA
 

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

Copy Formatting from one row to another using VBA
 

The macro recorder is your friend. Try it.

--
Don Guillett
SalesAid Software

wrote in message
ps.com...
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

Copy Formatting from one row to another using VBA
 

Thanks a ton!!!!!

Don Guillett wrote:
The macro recorder is your friend. Try it.

--
Don Guillett
SalesAid Software

wrote in message
ps.com...
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

Copy Formatting from one row to another using VBA
 

glad to help you help yourself

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Thanks a ton!!!!!

Don Guillett wrote:
The macro recorder is your friend. Try it.

--
Don Guillett
SalesAid Software

wrote in message
ps.com...
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