Results 1 to 6 of 6

Using a variable with the offset function

Threaded View

  1. 08-05-2013, 02:15 PM #1
    bbatterman
    bbatterman is offline
    Registered User
    Join Date
    04-04-2013
    Location
    Hortonville, WI
    MS-Off Ver
    Excel 2010
    Posts
    6

    Using a variable with the offset function

    [SOLVED] I have a row number defined in a variable (FHRow1) and I want to use that row number to offset from the active cell. I am using the following:
    ActiveCell.Offset(-FHRow1,0).Select and it does not work. What is the correct syntax for what I am trying to do?
    Thanks!
    Last edited by bbatterman; 08-05-2013 at 03:38 PM. Reason: [SOLVED]
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. function similar to offset to offset the offset
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2012, 03:07 PM
  2. Using variable in OFFSET function
    By kmoore in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2011, 12:13 PM
  3. OFFSET function with variable reference cell
    By smile2leksa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2009, 08:32 AM
  4. [SOLVED] Offset with variable?
    By John in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2006, 03:35 PM
  5. [SOLVED] Offset with variable
    By James in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2005, 04: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1