samedi 16 octobre 2021

select account from list, run macro, save, select next account and repeat until list complete

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