+ Reply to Thread
Results 1 to 6 of 6

VBA code to find the last row containing specific text

  1. 04-13-2019, 01:56 AM #1
    Excelski
    Excelski is offline
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    VBA code to find the last row containing specific text

    Hi,

    How do I write the code to find the last row that contains the text i)

    Thanks
    Kevin
    Reply With QuoteRegister To Reply
  2. 04-13-2019, 05:16 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,762

    Re: VBA code to find the last row containing specific text

    Moved to the VBA section.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-13-2019, 05:18 AM #3
    Excelski
    Excelski is offline
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: VBA code to find the last row containing specific text

    Thanks......sorry i should have posted here!
    Reply With QuoteRegister To Reply
  4. 04-13-2019, 07:34 AM #4
    ikboy
    ikboy is offline
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: VBA code to find the last row containing specific text 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by ikboy; 04-13-2019 at 07:36 AM.
    Reply With QuoteRegister To Reply
  5. 04-13-2019, 07:48 AM #5
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: VBA code to find the last row containing specific text

    I don't understand the use of RegExp for nothing...

    Quote Originally Posted by Excelski View Post
    How do I write the code to find the last row that contains the text i)
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 04-13-2019, 09:44 AM #6
    Excelski
    Excelski is offline
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: VBA code to find the last row containing specific text

    Thank you.......Both solutions work, I now need to try and understand how

    Kevin
    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] code find last cell in a specific column in specific worksheet and paste value
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2017, 10:38 AM
  2. [SOLVED] VBA to Find Specific Text, then Copy range to next open cell under specific text
    By Remotruker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2015, 10:59 AM
  3. InStr function doesn't find specific text, but finds any text in column and runs code
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 03:50 AM
  4. VBA code to find and highlight specific text in entire workbook not just active sheet
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-11-2014, 05:39 AM
  5. Find specific text in cell that matches range, then display specific text
    By Knawl in forum Excel General
    Replies: 2
    Last Post: 08-05-2013, 07:32 PM
  6. VBA Code to find and apply formatting to specific text strings
    By chozen86 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2008, 01:20 AM
  7. [SOLVED] UDF code to find specific text in cell comments, then average cell values
    By bruch04 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2005, 06:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1