Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Macro to copy

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    South Bend, IN
    Posts
    996
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mod needed to
    1) Convert formulas to values in columns A:F
    2)DELETE instead of hide columns G-Z

    Here is what I am using

    Sheets("Quote Tool").Select
    Sheets("Quote Tool").Copy
    Columns("G:G").ColumnWidth = 3.86 ' retain col widths ??
    Columns("G:G").Select
    Range("G2").Activate
    ActiveWindow.ScrollColumn = 2
    Columns("G:ak").Select
    Range("G2").Activate
    Selection.EntireColumn.Hidden = True
    Selection.Delete = True
    ActiveWindow.ScrollColumn = 1

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    North Alabama, USA
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well my favorite trick is to start a sequence with the macro recorder on. When I am finished go study the code. With just a little clean up it usually give me just what I wanted.

    HTH

    Rocky...

    [ This Message was edited by: Rocky E on 2002-04-29 11:03 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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