VBA to multiply any/all numeric cells in usedrange by a user-prompted value?

I'm trying to think of the best way to create a VBA macro that does the following...

1. Prompts user for a value.
2. Finds any/all cells in "UsedRange" that are NUMERIC (there are text cells it will need to ignore)
3. Multiply the cell value by the user-prompted value.
4. New value REPLACES old value in cell.

I know enough about the basics that I could probably trial-error my way through this in a couple hours.
However, I'm sure there must be an "easy" way.

My main concern is that I don't know if I can figure out how to detect ONLY the numeric cells.
Also, will I need a "FOR EACH" loop, or a "WITH" loop?

Thanks! I will test it out, ASAP.
Just an FYI, there are no date values in my data, only text (or general) and numeric.

Originally Posted by CK76

Please Login or Register  to view this content.

This worked great! I added

Please Login or Register  to view this content.

so that it would ignore empty cells.

How do I mark this question as SOLVED, or do the admins do it?

Got it, THANKS!