I am in the learning process. I borrowed some books from the library and made
some notes.
http://mai.home.att.net/VBA_notes.htm

Another good  way to learn is by using the macro recorder.

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

I just noticed this thread asking for free  tutorials.

Know that TechTrax is loaded with free tutorials  of all types and Mark
Thorpe create  a great series of excel  VBA newbie articles. You can find  them
at his article link here:

pubs.logicalexpressions.com/.../LPMFrame.asp
TH=33

I took a quick look and I think that I may find  my
answer in one of Mark Thorpe's articles.