macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You could use a directly written macro like the one below which wil
take every cell in the selected area and divide by 1000

Sub Divide
For Each Cell in Selection
Cell = Cell/1000
Next Cell
End Su
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting from list on separate sheet 2
Excel VBA 1
Macro driven record locator. 1
Excel Macro for deleting Rows containing dates greater than "today" 0
Macro Help 6
Excel Assistance with Fomula 0
Macro Query 1
Macro to use information in a cell to locate and send files using outlook 0

Back
Top