How can I get a macro to populate the answer into one specific cel

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I want to record a Macro that when clicked on, will run a formula and
populate the answer into the same specific cell every time it's clicked, no
matter what cell my cursor is active in at the moment I click the macro. Is
there a way to do this?

Right now I have the macro performing the calculation properly, but it
populates the answer into whatever cell I happen to be active in when I click
the macro. I want it to always populate the answer into one specific cell.

Any help would be greatly appreciated.
 
Sub SHARECALCA()
'
' SHARECALCA Macro
' Macro recorded 3/17/2009 by Matthew J. O'Neill
'

'
ActiveCell.FormulaR1C1 = "=MROUND((R6C3*100/R6C4),1000)"
Range("B6").Select
Selection.Copy
Range("B6").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub
 
hi
right now you formula is keying on C6 and D6 and pasting the results in B6.
is that what you want????

Regards
FSt1
 
Back
Top