Results 1 to 6 of 6

Copy/Paste Range(s) without activating/selecting Range(s)

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2008
    Location
    LOs Angeles
    Posts
    7

    Copy/Paste Range(s) without activating/selecting Range(s)

    To initialize some cells/ranges, I am copying a given range and pasting it to another given range using the .Copy and .PaseSpecial methods.

    However, it would seem that both methods actually select the range(s) for the operations, i.e. the given ranges(s) are activated/selected thus changing the focus on the spreadsheet.

    I would like to perform both operations without actually selecting the given ranges ... what is the (obvious) way to do so?

    Thanks,
    Last edited by hmissoumi; 10-03-2008 at 01:35 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 2D Array of named ranges
    By hilander in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2008, 08:02 PM
  2. Working with two ranges
    By udigold1 in forum Excel General
    Replies: 1
    Last Post: 08-27-2008, 10:04 AM
  3. Combine two ranges into one
    By hodges5378 in forum Excel General
    Replies: 5
    Last Post: 04-22-2008, 02:03 PM
  4. Date ranges between date ranges
    By kwuk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2007, 08:55 AM
  5. Named Ranges and Memory Usage
    By Rabk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2007, 07:36 PM

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