VBA to loop through a list of string values

**mb1824** · 08-11-2019, 05:41 AM

Hi, I have a Workbook with sheet names "110-actual", '213-actual", '566-actual"

I want to copy and paste the 3 sheets to another workbook.

How do I set up code to loop through a list like ("110","213","566"). The below doesn't work as Excel expects a ")" after "110"

Please Login or Register  to view this content.

**SjonR** · 08-11-2019, 05:51 AM

try this:

Please Login or Register  to view this content.

**MrGes** · 08-11-2019, 05:57 AM

Hi,

Please Login or Register  to view this content.

Change the directory

**jindon** · 08-11-2019, 06:04 AM

Originally Posted by mb1824

Hi, I have a Workbook with sheet names "110-actual", '213-actual", '566-actual"

I want to copy and paste the 3 sheets to another workbook.

Try

Please Login or Register  to view this content.

**Richard Buttrey** · 08-11-2019, 06:04 AM

Here's one way

Please Login or Register  to view this content.

**MrGes** · 08-11-2019, 06:28 AM

Edit: sorry, I had the wrong thread

**mb1824** · 08-11-2019, 06:29 AM

Hi all,

Thanks for your comments. Unfortunately i forgot to specify that I want the 3 tabs copied to 3 individual workbooks. Apologies for any inconvenience

**Richard Buttrey** · 08-11-2019, 06:43 AM

Just adapt and put the workbooks.Add instruction inside the loop

Please Login or Register  to view this content.

**jindon** · 08-11-2019, 06:58 AM

Originally Posted by mb1824

I want the 3 tabs copied to 3 individual workbooks.

Simply

Please Login or Register  to view this content.

**mb1824** · 08-11-2019, 07:35 AM

Sub test()
Dim e
For Each e In Array("101", "213", "566")
ThisWorkbook.Sheets(e & "-actual").Copy
Next
End Sub

Suppose in addition to "110-actual", '213-actual", '566-actual", I also have sheet names "110-budget","213-budget","566-budget".

How do I modify your suggestion to copy "110-actual" and "110-budget" into 1 workbook, "213-actual" and "213-budget" into a 2nd workbook and "566-actual" and "566-budget" into a third workbook?

I tried the below but it doesn't work

Please Login or Register  to view this content.

**jindon** · 08-11-2019, 07:39 AM

You have extra open bracket. should be

Please Login or Register  to view this content.

**jindon** · 08-11-2019, 09:20 PM

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

VBA to loop through a list of string values

LinkBack

Thread Tools

Rate This Thread

Display

VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Re: VBA to loop through a list of string values

Thread Information

Users Browsing this Thread

Similar Threads

Loop through the list and record values in another sheet

Compare Range list with String Array list (both same # of values)

Creating a string list of cell entry - Values from excel sheet into one string w seperator

Sum values if other cell contains the same text string + loop

Loop through list of data and calculate values

Loop using list of values

lookup loop to find values from a list inside a string of values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions