Results 1 to 16 of 16

Macro to copy pages from other tabs fails today,

Threaded View

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    Macro to copy pages from other tabs fails today,

    i used this code yesterday. all it is supposed to do is cycle through some worksheets and copy to a master page. the thing is that yesterday it worked, today it doesnt. any help is appreciated

    Sub dmcgov()
    For Each ws In ThisWorkbook.Worksheets
        Set c = Sheets("Formulas").Range("K19:K148").Find(ws.Name, lookat:=xlWhole)
        If Not c Is Nothing Then
        Sheets(c.Value).Select
        Range("B2:H324").Select
        Selection.Copy
        Sheets("Estimating1").Select
        Range("C2").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        End If
    Next
    End Sub
    so the range k:19 to k:148 are the names of the tabs, like A,B,C,D,...X,Y,Z,AA,BB,CC...ZZZZZ that i would like to cycle through, the sheets(c.value) should render A.value, the range is what i am copying, and estimating1 is the sheet i would like to do a paste value to. does this help?
    Last edited by dmcgov; 11-24-2015 at 02:13 PM. Reason: added code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. external data? It worked yesterday!
    By nitro805 in forum Excel General
    Replies: 3
    Last Post: 05-02-2013, 01:20 PM
  2. [SOLVED] Macro worked yesterday but not today?
    By Crawfinator1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-18-2013, 07:31 AM
  3. Created a userform in VBA that worked beautifully yesterday and crashed Excel today!
    By willneal in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-31-2012, 11:47 AM
  4. VBA-Find/Replace two strings--worked yesterday but not today
    By Royzer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2012, 05:28 PM
  5. Application.OnTime Hasnt worked since yesterday?
    By WAW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2012, 12:50 PM
  6. Code Worked Yesterday, Won't Work Today
    By mgaworecki in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-25-2009, 06:25 PM
  7. Yesterday macro worked, today it doesn't?
    By Nickster64 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2008, 12:47 PM
  8. worked yesterday- doesn't work today
    By Qaspec in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-25-2005, 01:06 AM

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