Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro
I have a worksheet with about 250 rows of data. There are about 200
workssheets. I want one particular column in a worksheet to be divided by 1000. When I try to record a macro, i get a message that says "unable to record". Please let me know if there is a solution to this. The cell contains a very long formula. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro
You could use a directly written macro like the one below which will take every cell in the selected area and divide by 1000 Sub Divide For Each Cell in Selection Cell = Cell/1000 Next Cell End Sub -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=549635 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |