+ Reply to Thread
Results 1 to 3 of 3

VBA equivalent for Range.select

  1. #1
    Forum Contributor
    Join Date
    01-09-2009
    Location
    Cedar Hill, Tx
    MS-Off Ver
    Excel 2003
    Posts
    200

    VBA equivalent for Range.select

    Howdy:

    Dumb question of the day...

    I have an application with row-wise data. When I double-click on any of the cells within that row, the first thing that I need to do is move "activeCell" to the left-most cell within that row (col "a") so that all of my activeCell.offset statements will work. What I use now is...

    Please Login or Register  to view this content.
    Any ideas on the VBA equivalent of that command?

    TIA.

    Bob

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA equivalent for Range.select

    that is vba so I don't get what you want?

    another question would be why does your code rely on selecting a cell in column a? ;-)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: VBA equivalent for Range.select

    That looks ok
    alternatively you can use

    Please Login or Register  to view this content.
    Elegant Simplicity............. Not Always

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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