+ Reply to Thread
Results 1 to 2 of 2

Most efficient way to copy multiple variables to specific cell locations using offset

  1. #1
    Forum Contributor
    Join Date
    06-25-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    179

    Most efficient way to copy multiple variables to specific cell locations using offset

    Hi,

    I have a list of variables all defined by offsets (due to the way a loop works)

    Example list:
    Please Login or Register  to view this content.

    I would like to copy these to another area of the sheet off to the side

    For example i want notional to go to 40,97 and product to 40,98 and so on.

    Whats the best way for me to copy these figures to their new location using the offset function?

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    06-25-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    179

    Re: Most efficient way to copy multiple variables to specific cell locations using offset

    Hi solved this by just just using setRange.offset(40,97) = notional for example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-05-2014, 04:07 PM
  2. Replies: 1
    Last Post: 05-07-2013, 02:49 PM
  3. Replies: 1
    Last Post: 11-14-2012, 01:33 PM
  4. create variables refering to cell locations with VBA
    By KATIEexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2012, 05:56 AM
  5. [SOLVED] Copy cell to specific locations based on certain conditions
    By aviatecar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2012, 12:52 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