[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Excel VBA

Posted on 2011-03-09
2
Medium Priority
?
351 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 100 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

612 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