Results 1 to 3 of 3

Macro: select entire range with empty columns in between

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    70

    Macro: select entire range with empty columns in between

    Im trying to select everything in a sheet starting with "A2"
    Here is my code:
    Range("A2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlToRight)).Select
    This works fine except sometimes there are empty columns in the middle of the data so it doesnt select everything. it selects up to that empty column. I want a code that will select everything up to the last column with something in it.

    Any Ideas?
    Last edited by nachousa; 07-27-2010 at 10:07 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