Results 1 to 8 of 8

OFFSET with variables

Threaded View

  1. #1
    Registered User
    Join Date
    05-15-2009
    Location
    Shreveport, LA
    MS-Off Ver
    Excel 2003
    Posts
    5

    OFFSET with variables

    I am trying to OFFSET from cell A1 based upon a variable in cell A2. The cell I need to OFFSET to is also located in column A, but it could always differ based upon the variable in A2. Here is the piece of code performing this OFFSET.

    'The current activecell is A1
     
    Dim ClaimNum As Integer
    ClaimNum = Range("A2").Value
    Activecell.Offset(ClaimNum,0).Select
    Originally, there was no error message; however, the cell was not offsetting (unless I changed the column reference, but it would move along Row 1, and never to another Row, which is the intent). Now I am getting a mismatch error. I tried using Find as well, but got the 1004 error. I am working across multiple spreadsheets, which may be part of the issue.

    Any thoughts??? Thanks in advance for any and all assistance.

    Grace
    Last edited by Grace310; 05-19-2009 at 09:56 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