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

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

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

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