Results 1 to 3 of 3

Based on tab label name in the beginning

Threaded View

Jerseynjphillypa Based on tab label name in... 08-01-2012, 03:07 PM
nilem Re: Based on tab label name... 08-01-2012, 03:21 PM
Jerseynjphillypa Re: Based on tab label name... 08-02-2012, 07:52 AM
  1. #1
    Forum Contributor
    Join Date
    10-16-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    112

    Based on tab label name in the beginning

    I am using the following code below for one excel file

    Set Rng = Sheets("_003_Table").Range("A1").CurrentRegion
    But when I copy the Macro to another excel file, instead of Table, it is List

    Set Rng = Sheets("_003_List").Range("A1").CurrentRegion
    is there any way to tell the Macro to only look for the tab label as "_003" in the beginning and NOT telling it to use the active sheet.

    Since with my Macro i have it creating Pivot tables and charts
    Last edited by Jerseynjphillypa; 08-02-2012 at 08:22 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1