Link to home
Create AccountLog in
Avatar of Ruchi_Sas
Ruchi_Sas

asked on

Excel VBA

I have calculated formula in one cell via VBA. Now I want to drag the same formula down till the rows count.
I am using
  Application.CutCopyMode = False
 ActiveCell.Select
 Selection.AutoFill Destination:=Range(rng & ":" & r & "7129")
 ActiveSheet.Calculate
 
This is copying values not the formula. Please let me know what I need to correct
Thanks
Ruchi
ASKER CERTIFIED SOLUTION
Avatar of kpltechgroup
kpltechgroup

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Ruchi_Sas
Ruchi_Sas

ASKER

There is link provided which did not provide enough information