Results 1 to 16 of 16

Creating Marco for varying number of sheets

Threaded View

  1. #5
    Registered User
    Join Date
    10-15-2016
    Location
    ATLANTA
    MS-Off Ver
    2016
    Posts
    16

    Re: Creating Marco for varying number of sheets

    Sorry i have updated my original post. The Marco code that i posted earlier, just deletes/formats rows and columns of source data. The only thing i looking for is a macro that will format the data on Sheet1 , Sheet2,...... SheetN, at the "same time", (Right now the data is formatted on each sheet "Individually") without impacting AA, BB, CC, & DD. Also i have tried using the below code, but its impacting AA,BB,CC, & DD sheets, which i do not want.

    
    Sub fm_tr()
    Dim xsheet As Worksheet
    For Each xsheet In ThisWorkbook.Worksheets
     xsheet.Select
    '
    '
     MY code here 
     '
     '
     '
     '
     Next xsheet
     
    End Sub
    Last edited by Roseline; 02-17-2019 at 03:05 PM. Reason: Updated

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a Marco to Replace a Specific Number with a Specific Letter in a Column
    By goldbeje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-27-2011, 11:26 AM
  2. VBA Marco/equations for creating reports
    By Deman_250 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2011, 03:00 AM
  3. Collating data from varying number of sheets
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2009, 08:22 PM
  4. Exclamation Collate data from varying number of sheets to one sheet
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2009, 06:07 PM
  5. Replies: 0
    Last Post: 11-26-2009, 04:53 PM
  6. Selecting an array with a varying number of sheets
    By cbjorgol in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2008, 09:41 AM
  7. Generic Page Setup Macro applied to multiple workbooks with varying number of sheets
    By sowetoddid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2005, 11:45 AM
  8. [SOLVED] VARYING number of sheets in EXCEL
    By Darrin in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-22-2005, 12:06 PM

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