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
|