+ Reply to Thread
Results 1 to 4 of 4

SpecialCells Extend Selection

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    SpecialCells Extend Selection

    Hello all,

    I recorded the following macro that selects all non-blank cells in A:A
    Then I used the Shift and Movement Keys to extend the selection till column U.

    However, when recording this the range is set to A1:U59 which was the outcome that specific situation. The range however varies, and I'd like to code to do the same.

    Please Login or Register  to view this content.
    an ideas?

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: SpecialCells Extend Selection

    hi, Jonathan78, I would suggest to do that this way:
    Please Login or Register  to view this content.
    myrange will hold range address string as a result

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: SpecialCells Extend Selection

    Assuming your data is all one block, as it appears, you could use:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  4. #4
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: SpecialCells Extend Selection

    Thanks Romperstomper, this one works just fine

+ Reply to Thread

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