VBA macro loop
Closed
bjj127
Posts
1
Registration date
Wednesday November 1, 2017
Status
Member
Last seen
November 1, 2017
-
Updated on Nov 1, 2017 at 01:46 PM
Blocked Profile - Nov 1, 2017 at 06:51 PM
Blocked Profile - Nov 1, 2017 at 06:51 PM
Related:
- VBA macro loop
- Vba case like - Guide
- Fruit loop studio - Download - Musical production
- Number to words in excel without vba - Guide
- Game loop - Download - Android emulators
- Enable vba in excel - Guide
1 response
Can you chop this up into smaller functions, or subroutines, that produce an expected output? Then call each subroutine, so you can troubleshoot (and understand how to pass the variable into the routines that need them). BTW, I didn't notice any loop.
In the case of the sheet name, build another variable like:
Try that!
In the case of the sheet name, build another variable like:
thesheetname(0)= ActiveSheet.Name & "With" & Nsubperiods & "Periods"
Try that!