Results 1 to 5 of 5

storing activecell.row value for later use?

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    22

    storing activecell.row value for later use?

    a=Activecell.Row
    
    Activecell.Row
    range("table1[location]").Select
    selection.End(xlup).select
    Offset(a, 0).select
    With the above, once the selection changes on the second line of code the 'a' active row location number will be different as the current selected cell has changed

    Is there a way to store the row number in the first 'ActiveCell.Row' line of code for reference in the 'Offset(a,0).Select

    Many thanks
    Last edited by hb316; 09-11-2013 at 06:33 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Output contents of Activecell when Activecell may be string or numeric.
    By jfriddle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 12:27 PM
  2. How to set the Activecell of "Sheet2" to Activecell of "Sheet1"
    By shawnh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2010, 11:12 PM
  3. [SOLVED] storing value's
    By ashw1984 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2006, 12:25 PM
  4. Storing Values
    By dinesh in forum Excel General
    Replies: 0
    Last Post: 06-10-2005, 01:33 AM
  5. Storing a Value
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2005, 06:26 PM

Tags for this Thread

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