Results 1 to 5 of 5

How to minimise .Select in Macros?

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2008
    Location
    UK
    Posts
    11

    How to minimise .Select in Macros?

    Greetings,

    I'm writing some code that analises data and I have been adviced that it is good practice to minimise the function .Select in macros, especially when i'm just copying and pasting stuff. (as .select will make the screen jump from one sheet to the other and back etc.

    but how do I minimise .Select in this example:
    Sheets("sheet1").Select
        Range("A13").Select
        Selection.Copy
        Sheets("sheet2").Select
        Range("F12").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    Many thanks
    Michiel
    Last edited by MichielEngineer; 11-10-2008 at 07:40 AM.

Thread Information

Users Browsing this Thread

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

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