brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I have a named range for Entries which is a list of names for my event
I want to start with the first name, enter the value in Range ("Receipt!C48")
Then run my code
then put the next name on the list into Receipt!C48
Then run my code again
Continue this until the last name is entered.
I am running the macro while on the Receipt Worksheet and the list of names are in the Entries worksheet. My code needs to run on the Receipt Worksheet.
I have worked with looping macros and can do this but my way is exceedingly slow and clumsy.
Can anyone please help me with a code which will run quickly and efficiently to do this.
Excel Formula:
=OFFSET(Entries!$A$10,0,0,COUNTA(Entries!$A$10:$A$209),1)
Then run my code
then put the next name on the list into Receipt!C48
Then run my code again
Continue this until the last name is entered.
I am running the macro while on the Receipt Worksheet and the list of names are in the Entries worksheet. My code needs to run on the Receipt Worksheet.
I have worked with looping macros and can do this but my way is exceedingly slow and clumsy.
Can anyone please help me with a code which will run quickly and efficiently to do this.