Results 1 to 10 of 10

Select non-empty cell range with VBA

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    20

    Select non-empty cell range with VBA

    Hello,

    First of all i want to thank the people that helped me with my previous question.

    I would like to ask for help with the following issue - i have three columns that look like this:
    1.png
    Which should have a selection around them like this:
    2.png

    The macro should ignore rows that do not contain values in all of the three columns.

    Unfortunately i do not know VBA, i have searched for this issue on Google and found some information but i cannot put them together.
    For exemple:
    http://www.mrexcel.com/archive/VBA/21407.html
    http://stackoverflow.com/questions/8...excel-with-vba

    Thank you for your time.
    Daniel.
    issue2.xlsm
    Attached Images Attached Images
    Last edited by mexykanu; 12-09-2013 at 10:24 AM. Reason: Solved!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Select the last empty cell of the range specific
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2013, 09:48 AM
  2. Select Empty Cell Within a DropDown List Box's Range
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2010, 06:58 PM
  3. [SOLVED] Macro to find empty cell and select range to print selected.
    By vincentwongau@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2006, 04:10 AM
  4. select first empty cell in a range
    By Shawn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2005, 08:05 PM

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