Hi

This is my first posting here, well anywhere really.

Trying to teach myself all about VBA in my spare time

What I want to do is get the following command to repeat in the cell
below

ie row 8,9 ect to row 207

Private Sub CommandButton2_Click()

Dim rng As range
Set rng = Sheets("Dispensary").range("f7")
rng.Value = rng.Value + range("h7")
range("h7") = 0

End Sub

Probably really easy but cannot find how to do it anywhere.

Hope someone can help

Cheers Davey
:confused

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