Solved

Excel VBA

Posted on 2011-03-09
2
330 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

Backup Your Microsoft Windows Server®

Backup 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.

Join & Write a Comment

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
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…

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now