Running a macro, want a cell to be updated with the next account number and rerun the macro. in 1 instance went to 2nd account in list. but the following is not working. Suggestions?
Dim ws As Worksheet, rng As Range Set ws = Worksheets("summary") 'ws with list of fund numbers Set rng = ws.Range("L7") '1st row with fund numbers
Range("LIST") = rng
Do Until IsEmpty(rng)
Call runitallpls
Set Range("rng") = rng.Offset(1, 0)
'select next fund number by stepping down 1 row from list
Loop
End Sub
Aucun commentaire:
Enregistrer un commentaire