| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Batch update cell values
Sub Make_200()
Dim cell As Range For Each cell In Selection If cell.Value 200 Then cell.Value = 200 End If Next End Sub Gord Dibben MS Excel MVP On Tue, 20 Feb 2007 07:52:15 -0800, Moshe Rosenberg wrote: I need to batch update all cell values in a sheet over the value of 200 to become 200. How can I accomplish this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Values in spreadsheets do not update | Excel Worksheet Functions | |||
| How to delete in batch the same color format letters in a cell | Excel Worksheet Functions | |||
| Update of cell values after insert row? | Excel Worksheet Functions | |||
| How does one update and transfer values between cells and not the. | Excel Discussion (Misc queries) | |||
| How does one update and transfer values between cells and not the. | Excel Discussion (Misc queries) | |||
Threaded Mode
