Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dump macro result into cell
I currently am running a macro that sums the numerical values from a chain of
numbers and letters. What can I add to the macro to have the macro dump the sum from the chain into the cell immediately to its right? I'd like this to work for each cell in my column. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dump macro result into cell
One way:
Dim dSum As Double Dim rCell As Range With Sheets("Sheet1") For Each rCell in .Range("A1:A" _ .Range("A" & .Rows.Count).End(xlUp).Row) dSum = <your code here rCell.Offset(0, 1).Value = dSum Next rCell End With In article , DB wrote: I currently am running a macro that sums the numerical values from a chain of numbers and letters. What can I add to the macro to have the macro dump the sum from the chain into the cell immediately to its right? I'd like this to work for each cell in my column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write Macro to Fix Data Alignment (Data dump from Crystal to Excel | Excel Discussion (Misc queries) | |||
VBA and SQL dump changing the cell types in other worksheets | Excel Programming | |||
how do I automatically run a macro from the result of a cell | Excel Programming | |||
How to run a Macro depending on a result of a cell | Excel Programming | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |