Results 1 to 8 of 8

Thread: VBA code to find last entry on a certain date and bring back the text in the adjacent

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 03-10-2014, 10:25 PM #1
    pedros23
    pedros23 is offline
    Junior Member
    Join Date
    Jan 2014
    Posts
    9
    Rep Power
    0
    Hi Alan,

    Thanks for the reply, however when I run the macro I get a Run-time error 9 - Subscript out of range.
    Last edited by Admin; 03-11-2014 at 07:43 AM. Reason: quote removed
    Reply With Quote Reply With Quote
  2. 03-11-2014, 04:19 AM #2
    alansidman
    alansidman is offline
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    14
    Example Fund.xlsm

    Unable to duplicate your issue. Here is the file that I tested on.
    Alan
    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    Like my answer? Click * below
    Database Normalization
    Database Principles
    Pivot Table Tips
    Excel Video Tutorials
    SumProduct Video Tutorial
    DataPig Access Tutorials
    MS Query Tutorial
    SQL Tutorial
    Reply With Quote Reply With Quote
  3. 03-11-2014, 01:48 PM #3
    pedros23
    pedros23 is offline
    Junior Member
    Join Date
    Jan 2014
    Posts
    9
    Rep Power
    0
    Quote Originally Posted by pedros23 View Post
    Hi Alan,

    Thanks for the reply, however when I run the macro I get a Run-time error 9 - Subscript out of range.
    The following is highlighted

    lr = Sheets("Summary").Range("A" & Rows.Count).End(xlUp).Row
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. data entry to correct cell range...code needs help
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 08-28-2013, 05:26 PM
  2. Find Maximum Value Corresponding To Adjacent Column
    By shonu in forum Excel Help
    Replies: 6
    Last Post: 05-22-2013, 02:23 AM
  3. Vba Code to find value and paste on certain row
    By jwitte in forum Excel Help
    Replies: 3
    Last Post: 11-28-2012, 08:52 PM
  4. Date References to save files using VBA Code
    By mrmmickle1 in forum Excel Help
    Replies: 3
    Last Post: 11-28-2012, 05:48 PM
  5. Find The Last Entry Row In A Column That Contains Only Numbers
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-09-2011, 05:19 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