excel macro

[dsp1899]

i have three seperate cells A1, B1, and C1.
I need a macro to add B1 and C1 then transfer it to A1.
This needs to happen on a certain date in the month.
If anyone can help i would greatly appreciate it.

 

[Smitty]

Welcome to the Board!

For the first part, you can use something like this:

Sub AddMe()
    Sheets("Sheet1").Range("A1") = Range("B1").Value + Range("C1").Value
End Sub

What is the criteria for the date that this needs to happen? First Monday, specific date, etc. And what date format are you using?

Hope that helps,

Smitty

 

[dsp1899]

i get an error of "Script out of range"
Any ideas

 

[Greg Truby]

Do you have a "Sheet1"?

You could just write

[A1] = [B1] + [C1]

 

[Smitty]

From a PM:

The date need to be the first monday of every month. I am not sure on the format of the date. This can be what ever.

As for the subscript out of range error, you actually need to have a "Sheet 1" with my example. Change the code reference to Sheet 1 to whatever the sheet in question is.

Hope that helps,

Smitty