+ Reply to Thread
Results 1 to 3 of 3

Can I use offset from another sheet?

  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    utica, ny
    MS-Off Ver
    Excel 2003
    Posts
    4

    Can I use offset from another sheet?

    I'd like to cycle through a range testing values on a sheet without activating it - the main reason being the trigger event is when a tab is activated, and if I have to reactivate it I get into an infinite loop. So I'm trying to figure out something like this, the asterisk line being where I'm hanging up. Hopefully you get the idea

    oop = Sheets("Pricing Defs").Range("c23").Value

    r = Sheets("Pricing Defs").Range("c16").Value


    x = Sheets("Deductible Factors 2017").Range("l5").Value

    i = 0

    Do Until x > oop
    i = 1 + i
    x = Sheets("Deductible Factors 2017").Range("l5").Offset(i, 0).Value*****

    Loop

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Can I use offset from another sheet?

    Are you aware you can turn events off then run your code THEN turn events back on?

    Please Login or Register  to view this content.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    07-12-2012
    Location
    utica, ny
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Can I use offset from another sheet?

    Great! That worked

+ 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. Capture sheet formulaR1C1local, paste into another sheet and offset by 1 column
    By evancharles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2015, 03:06 PM
  2. Replies: 9
    Last Post: 11-07-2014, 07:10 AM
  3. Offset SUM from different sheet
    By alimagator in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-02-2013, 11:20 AM
  4. Macro: Count rows in sheet A, copy count in sheet B, paste offset in sheet A
    By Agent:Orange in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2011, 07:56 AM
  5. From cell in sheet 2 find name in sheet 1 and value offset
    By Frank345 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-05-2008, 01:50 AM
  6. Using offset more than once on the same sheet
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2005, 07:05 PM
  7. Sheet Offset - is this possible?
    By MichaelC in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-12-2005, 03:05 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