Copy and Paste Number Formatting Only

I've got this to work for copying a single cell and pasting over a selection of cells:

Please Login or Register  to view this content.

Then I tried changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and got an error code.

Anybody know how to copy or store number formats over a selection?

I'm trying to just copy the number formatting from a row to new rows below it.
I don't need the values or colors and most the time there is data already in the rows below so I'd like to not have it messed with.

Hi tricky,

I'm trying to just copy the number formatting from a row to new rows below it.

Try the following. It copies number formats and formulas. If any of your source rows have formulas you don't want to replicate, the formulas can be removed from the destination rows.

Please Login or Register  to view this content.

Lewis

Maybe :

Please Login or Register  to view this content.

Thanks to both of you for your time. karedog your code seems to be working good. I think it will do.

You are welcome, and thanks for the reputation points.


Regards