Hi -
I am new to VBA, so this may be easier than I think. I have
spreadsheet that is set up into three sheets. Sheet one is
calculation, sheet 2 has all the values that I need to be calculate
individually, and sheet3 is where the answer from the calculation i
pasted. The code I am using so far is this:

Range("A1").Select
Selection.Copy
Sheets("Sheet1").Select
Range("B4").Select
ActiveSheet.Paste
Range("B4:D4").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet3").Select
Range("A1").Select
ActiveSheet.Paste

That does what I want it to for one selection (A1). However, I want t
have this repeat for cells A1:A10 on Sheet 2 and have it pasted o
A1:A10 on Sheet 3 respectively.

Basically I want to perform an individual calculation that loops. Doe
anyone know how to combine these?

Thanks

--
Message posted from http://www.ExcelForum.com