Results 1 to 7 of 7

Loop for all Worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2008
    Location
    Manila, Philippines
    Posts
    20

    Loop for all Worksheets

    hELP ME SO i CAN run THIS codeS to all worksheets in the activeworkbook AT ONE TIME,(e.i. Oct 2008). I record this macro IN my Personal macros as 'Macro5.'
       Windows("IDF Clearing Template REVISED.xls").Activate
        Rows("1:2").Select
        Range("BE1").Activate
        Selection.Copy
        Windows("Oct 2008.xls").Activate
        Rows("1:1").Select
        Range("BG1").Activate
        Selection.Insert Shift:=xlDown
        Windows("IDF Clearing Template REVISED.xls").Activate
        Columns("BM:BQ").Select
        Application.CutCopyMode = False
        Selection.Copy
        Windows("Oct 2008.xls").Activate
        Application.WindowState = xlMinimized
        Columns("BM:BM").Select
        ActiveSheet.Paste
        Range("BN2").Select
        Application.Run "'IDF Clearing Template REVISED.xls'!Macro1"

    Thanks and best regards
    Last edited by royUK; 12-08-2008 at 11:41 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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