Cell Content
 

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.

Cell Content
 

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)"

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)"

Thanks for your help. I will give it a try.

Frank

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

Cell Content
 

On Jan 16, 7:50*pm, wrote:
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
somthing like this?

Dim i As Variant
i = InputBox("Additional number to add?")
Range("B1").Formula = "=sum(A1:A6," & i & ")"

Cell Content
 

On Jan 16, 9:29*pm, GTVT06 wrote:
On Jan 16, 7:50*pm, wrote:



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

somthing like this?

Dim i As Variant
i = InputBox("Additional number to add?")
Range("B1").Formula = "=sum(A1:A6," & i & ")"- Hide quoted text -

- Show quoted text -

I just tried your suggestion and it does what I was looking for.

Thanks,
Frank