+ Reply to Thread
Results 1 to 8 of 8

Select blank cells used range rows and columns

  1. #1
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Select blank cells used range rows and columns

    Hi All,

    Hope you can help me figure out how can I select used range rows and columns and paste the desired formula. Ok my problem selecting the blank cells(count of rows and columns not fixed)

    On my sample workbook I attach here, rows occupied is until row 42 and columns on row 2(Col H) I just want to select B3 to H3 down to row 42(but then I just want to clear that used range of column and rows is not fix). Your help on what code should I used will be appreciate.
    Attached Files Attached Files
    Last edited by emina002; 02-27-2015 at 10:12 AM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Select blank cells used range rows and columns

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Re: Select blank cells used range rows and columns

    Hi @John Davis,this is what I am looking for. I copied already on my actual file and adjusted the code. On my actual file,the Activities column start on Col D. I just cant get it right on how to adjust the used range rows.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Select blank cells used range rows and columns

    Can you attach a sample showing your actual file layout?

  5. #5
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Re: Select blank cells used range rows and columns

    Hi @John Davis,

    Here is the actual file.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Select blank cells used range rows and columns

    Does this help?

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Re: Select blank cells used range rows and columns

    Yes! Thank you so much @John Davis

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Select blank cells used range rows and columns

    You're welcome. Glad to help out and thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select range, skip columns/rows
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2015, 07:12 PM
  2. [SOLVED] Select variable range; identify & delete rows with blank cells
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-28-2013, 04:40 PM
  3. Select range between blank cells
    By zel in forum Excel General
    Replies: 5
    Last Post: 05-13-2011, 03:57 AM
  4. Count blank cells within a range not including fully blank rows
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-16-2008, 09:43 AM

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