| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Operate on each cell in range.
How do I put wrapper code around the below, so that I can select a
range of "many" cells and have the code execute on each cell in turn? For each cell in selected range (selection) . . . Sub Adjust_Formula() ActiveCell.Formula = "=" & ActiveCell.Value * 2 & "*(QTR/4)" End Sub The formula works fine on a single cell. Many thanks, Fred Holmes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Operate the active Excel Window with VB6 | Excel Programming | |||
| The formula to operate in shhet2 please. | Excel Worksheet Functions | |||
| Function to operate on ink linked to cell | Excel Worksheet Functions | |||
| tell excel to operate in hexadecimal ( base 16)? | Excel Worksheet Functions | |||
| Can Excel operate as Database? | Excel Programming | |||
Threaded Mode
