I went to the library today and the few
VBA books they had were checked out. I am on the waiting list.

I was working on my project  today and have what might be a simple
question. How do you write new data into a spreadsheet cell? I have
a cell for Year to Date Earnings and what I want to do is to keep it
current. I think that I have gotten the cell data into variables.
Now I need to add the two variables together and put the result in the
spreadsheet. Can you assist.

At the risk of really showing how much of a hack I am :-0, I am
putting my code below.

' Select the cell in the spreadsheet that has today's data
Range("f6").Select 'the cell is F6
' Assign a variable to the current day total
total = ("f6")
' Select the spreadsheet cell that has the current year total
Range("f7").Select
' Assign a variable to the current year total
mtd = ("f7")
' Write the NEW year to date total in cell F7
"f6" = mtd+total '<----This is the statement that doesn't work