Consulting

Results 1 to 4 of 4

Thread: Amendment to Existing Macro

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie EmmaFairclough's Avatar
    Joined
    Jun 2004
    Location
    In a little world of my own!
    Posts
    2
    Location

    Amendment to Existing Macro

    I've got part of a macro completed thanks to theofficeexperts but then received a pm to visit here and thought I'd come and say hello to you lovely people!!

    The macro looks like this
    Sub CreateSummary()
    Application.ScreenUpdating = False
    Dim ws As Worksheet
    Dim f As String, x As String
    f = "SUMMARY"
    For Each ws In ThisWorkbook.Worksheets
        ws.Activate
        If ActiveSheet.Name = f Then GoTo circumv1
        x = ActiveSheet.Name
        If Range("J65536").End(xlUp).Row = 1 Then GoTo circumv1
        Range("A2", Range("J65536").End(xlUp)).Copy
        With Sheets(f)
            .Range("A65536").End(xlUp).Offset(1).Value = x
            .Range("A65536").End(xlUp).Offset(1).PasteSpecial (xlPasteAll)
        End With
        circumv1:
    Next ws
    Sheets(f).Select
    Application.ScreenUpdating = True
    End Sub
    It works really well except that I want it to copy over one set of headings and make the page names bold.

    Any ideas??

    Last edited by Anne Troy; 06-25-2004 at 05:50 AM.

Posting Permissions

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