+ Reply to Thread
Results 1 to 4 of 4

Find Row of Last Occurrence of a String

  1. 04-14-2023, 06:55 AM #1
    Lewis Clark
    Lewis Clark is offline
    Registered User
    Join Date
    12-26-2012
    Location
    Florida
    MS-Off Ver
    Office 365
    Posts
    50

    Find Row of Last Occurrence of a String

    Hello Everyone

    The attached workbook contains a sample of a general ledger containing four accounts.

    I need a VBA statement that will give me the row number of the last cell in column B containing the word "Account". With this sample data, the statement should return Row 35.

    Thank you very much in advance for all assistance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-14-2023, 07:07 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,331

    Re: Find Row of Last Occurrence of a String 

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 04-14-2023, 08:43 AM #3
    Lewis Clark
    Lewis Clark is offline
    Registered User
    Join Date
    12-26-2012
    Location
    Florida
    MS-Off Ver
    Office 365
    Posts
    50

    Re: Find Row of Last Occurrence of a String

    Thank you very much for your fast reply! Works perfectly.
    Reply With QuoteRegister To Reply
  4. 04-14-2023, 09:56 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,331

    Re: Find Row of Last Occurrence of a String

    Glad to have helped...Tx for rep +
    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] Find a Last Occurrence of a String
    By Ricker090 in forum Word Programming / VBA / Macros
    Replies: 9
    Last Post: 11-02-2019, 02:45 AM
  2. Find specified occurrence of specific text string?
    By mrbusto71 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2016, 10:44 PM
  3. Find last occurrence of a string in a specific column
    By Adam Brave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2016, 11:39 AM
  4. [SOLVED] find last occurrence of a non-exact text string in unsorted table and return next column
    By pjstevenson in forum Excel General
    Replies: 3
    Last Post: 09-15-2014, 07:56 PM
  5. Find the last occurrence of a character in a string
    By LAF in forum Excel General
    Replies: 7
    Last Post: 08-31-2013, 12:30 PM
  6. Find the row number of the 2nd occurrence of a string in a range
    By seaottr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2011, 06:52 PM
  7. Find first occurrence of text string and apply filter
    By Kenton in forum Excel General
    Replies: 0
    Last Post: 07-29-2011, 08:44 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