VBA MAcro Code Question..Is it possible??

Jack_58 · Mar 30th, 2004, 07:49 PM

How would it be possible to write code to have my macro take the current figure that is in the sum of the column and continue with the macro? The current code looks like this

ActiveCell.FormulaR1C1 = "=RC[-1]/3223894.484"
ActiveCell.Select
Selection.Copy

However the Number will be a different figure, based on the rest of the figures in the column.

Is it possible to have Excel automatically detect and copy the figure calculated in that cell, which is Dynamic?

Thanks in advance.

Jack

Mar 30th, 2004, 07:49 PM	#1
Jack_58 Join Date: Dec 2002 Posts: 208	VBA MAcro Code Question..Is it possible?? How would it be possible to write code to have my macro take the current figure that is in the sum of the column and continue with the macro? The current code looks like this ActiveCell.FormulaR1C1 = "=RC[-1]/3223894.484" ActiveCell.Select Selection.Copy However the Number will be a different figure, based on the rest of the figures in the column. Is it possible to have Excel automatically detect and copy the figure calculated in that cell, which is Dynamic? Thanks in advance. Jack

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode