Hello all,
Another simple question. What I want do here is do this
formula down through column B. B1 would be A1*increase, B2
would be A2*increase, etc.
I know this is simple enough to do in Excel but.... I'm
trying to learn VBA.


dim increase as integer
increase = Range("H1")

For Each c In Sheets("sheet1").Range("A1:A10")

c.Value = Range("B1") * increase
Next c

Which brings me to my second question. Does anyone (or
website) have sample or old SS w/ code that I could have
to see how simple things work. Some code is basic and
repeating (how to hide a row, how to enter a custom
toolbar)and needed to use VB code realistically. I'm
learning but it's taking forever reading help files and
this newsgroup. When I can record a macro and look at it ,
things make more sense so I was hoping.....

THanks in advance for any and all help
jeffP