| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks,
This looks simple and repects my active cell. "JE McGimpsey" wrote: One way: Public Sub SubtractA1() Range("A1").Copy ActiveCell.Resize(1, 30).PasteSpecial _ Paste:=xlValues, _ Operation:=xlSubtract, _ SkipBlanks:=False, _ Transpose:=False Application.CutCopyMode = False End Sub In article , "Kanga 85" wrote: I need a macro that will do the following: Take the cell highlighed and the next 29 cells in that row, Subtract the value of A1 from each of these cells and paste the new value (not the formula) into the same 30 cells, Do this only once. Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
| Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
| Avoiding circular reference on formula | Excel Discussion (Misc queries) | |||
| Help solve a Circular Reference | Excel Worksheet Functions | |||
Hybrid Mode
