+ Reply to Thread
Results 1 to 3 of 3

Find Value 0 in Column A:A then Select Range

  1. 10-04-2015, 02:19 AM #1
    tuongtu3
    tuongtu3 is offline
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    810

    Find Value 0 in Column A:A then Select Range

    Hello All,
    Please look at sample attached that I need help to look for value "0" in Column "A:A" then select range until last value "0" in Column "A:A"

    Regards,
    tt3
    Attached Files Attached Files
    Last edited by tuongtu3; 10-04-2015 at 03:37 AM. Reason: SOLVED
    Reply With QuoteRegister To Reply
  2. 10-04-2015, 03:17 AM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,519

    Re: Find Value 0 in Column A:A then Select Range

    Try
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-04-2015, 03:37 AM #3
    tuongtu3
    tuongtu3 is offline
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    810

    Re: Find Value 0 in Column A:A then Select Range

    Hi Jindon,
    That's perfect and thank you very much for your help.

    Regards,
    tt3
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need VBA to find letter A in Column A:A, select range, popup MsgBox then loop
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2015, 04:05 AM
  2. [SOLVED] How to find text then select RANGE form the text found to lastrow of Column J
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2014, 02:45 AM
  3. Sort Select Range: Either Find Column Header or Last Column:Last Row
    By mbryson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2014, 08:03 AM
  4. [SOLVED] Find first blank cell in first column of known range, select and delete from that point
    By johnstevens in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-09-2014, 09:41 AM
  5. Find & select 1st blank cell in a range of formulated column cells
    By jnbroek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 09:26 AM
  6. Look up cell, use as reference to select from a range, to then select data in a column...
    By transportplanner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2013, 05:21 AM
  7. [SOLVED] Trying to find a value in a column, then select a range in that row to delete VBA
    By miltonsrevenge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2012, 03:01 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1