Solved

Excel VBA

Posted on 2011-03-09
2
334 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:Ruchi_Sas
2 Comments
 
LVL 5

Accepted Solution

by:
kpltechgroup earned 50 total points
ID: 35089849
0
 

Author Closing Comment

by:Ruchi_Sas
ID: 35213540
There is link provided which did not provide enough information
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question