Thread: Cell Content
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] wfgfreedom@gmail.com is offline
external usenet poster
 
Posts: 28
Default Cell Content

On Jan 16, 7:05*pm, GTVT06 wrote:
On Jan 16, 4:50*pm, wrote: I am trying to use a Macro to sort through a table of numeric values
and modify the values based on a series of If statements. *Can someone
tell me if the contents of a cell can be modified with a Macro, other
than simple Copy/Cut/Paste funstion?


Can I include Excel Formula such as (=A1+A6) in a Macro?


Frank.


hello,
you can modify the value of a cell in a macro by writing a command
similar to:
Range("A1").Value = 123
and you can enter a formula by writing a command similar to:
Range("B1").Formula = "=sum(A1:A6)"


I tried the command and it works well. Howver, I also would like to
introduce a variable into the equation as follows:
Range("B1").Formula = "=sum(A1:A6)" + Variable

Is this possible?

Frank