Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
"MultiplyTimes1000" macro
Posted by Dwight on May 30, 2001 11:10 AM
Want a macro which I can run after selecting a range of cells which will multiply the entire range by 1000, leaving formatting intact.
Any ideas?
| Check out our Excel VBA Resources
|
 |
 |
 |
 |
 |
Re: "MultiplyTimes1000" macro
Posted by Mark W. on May 30, 2001 11:20 AM
Take a look at ASAP Utilities' Numbers |
Apply formula to selected cells command.
Free at www.asap-utilities.com
Re: "MultiplyTimes1000" macro
Posted by Tom on May 30, 2001 11:22 AM
Dim cell As Range
For Each cell In Selection
If IsNumeric(cell) And cell <> "" Then cell.Value = cell * 1000
Next
Note : If any of the cells in the selection contain formulas, the above will convert them to values only
ASAP+
Posted by Aladin Akyurek on May 30, 2001 11:33 AM
Hi Mark
Bastien, a Dutch guy as it turned up, informed that his utilities are not available for the Mac because he doesn't have access to a Mac.
Aladin
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.