Loop through a set number of sheets starting with inputted initial sheet name

**declan1983** · 03-16-2022, 03:19 PM

I am trying to set the following piece of code to be able to loop through a set of sheets starting with Date1 (inputted from active worksheet), and continuing for the duration of the Result. An example would be Date1: 03-03-2022, Result: 8, For statement would start on the workbook at 03-03-2022 and copy the date for the next 8 sheets.

Please Login or Register  to view this content.

https://www.mrexcel.com/board/thread...-name.1199307/

**protonLeah** · 03-17-2022, 12:01 AM

Date1: 03-03-2022 has a numeric value of 44623, so the line

For i = Date1 To Result

compiles to

For i = 44623 To 8

and the loop won't execute. also

.Value = CStr(wb2.Worksheets(i).Name)

results in

.Value = CStr(wb2.Worksheets(44623).Name)

So change to
For i = 1 To Result

Loop through a set number of sheets starting with inputted initial sheet name

LinkBack

Thread Tools

Rate This Thread

Display

Loop through a set number of sheets starting with inputted initial sheet name

Re: Loop through a set number of sheets starting with inputted initial sheet name

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sum of units over a time period starting with initial units and a known growth rate

Display any number of table rows starting on another sheets predefined row

[SOLVED] Standard Payback period with different starting dates of initial investmets

Get column and first cell of inputted range to increment off of in FOR loop

Sum across the Sheets , Starting from first to Specified sheet

[SOLVED] Create a Drop down that will list all names starting with initial letter of names.

need calculation to add sums starting one less than starting number

Bookmarks

Bookmarks

Posting Permissions