+ Reply to Thread
Results 1 to 5 of 5

Find last row with data and pass the found row number to bookmark code

  1. #1
    Forum Contributor
    Join Date
    10-07-2013
    Location
    Wilts, England
    MS-Off Ver
    Excel 2013
    Posts
    100

    Question Find last row with data and pass the found row number to bookmark code

    Hi all,
    Having some issues with this script. I am trying to find the last row with data and pass the row number to my bookmark code so that the code populates the bookmarks I have set up in word template.
    So what I have so far keeps getting stuck with an error message "Method 'Range' of oject'_Global'failed.
    I don't believe it is selecting the row number correctly, but I'm not sure.
    Here is the code I have so far;

    Please Login or Register  to view this content.
    Any help would be wonderful!!
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Find last row with data and pass the found row number to bookmark code

    Which range is this referring to? Word or Excel.
    Please Login or Register  to view this content.
    You have to specify.
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    10-07-2013
    Location
    Wilts, England
    MS-Off Ver
    Excel 2013
    Posts
    100

    Re: Find last row with data and pass the found row number to bookmark code

    Thank you for the advice, its the excel range. I tried your suggestion but it comes back with an "Application-defined or object-defined" error.
    Is there somthing else I'm missing?

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Find last row with data and pass the found row number to bookmark code

    Quote Originally Posted by beenbee View Post
    Is there somthing else I'm missing?
    Not you, me. <slaps forehead>


    Quote is out of place.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    10-07-2013
    Location
    Wilts, England
    MS-Off Ver
    Excel 2013
    Posts
    100

    Re: Find last row with data and pass the found row number to bookmark code

    Lol Oh damn, its always somthing that simple. Thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search for decimal and when found pass row number to rest of string
    By beenbee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2014, 07:14 AM
  2. Loop through Column to find decimal then pass found row to bookmark code
    By beenbee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 11:13 AM
  3. [SOLVED] Find number and delete until tje number is not found above it
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2013, 04:36 PM
  4. [SOLVED] find duplicate number and return total found
    By HelpHelpHelp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-26-2012, 08:27 AM
  5. Number of cells found by .Find/.FindNext
    By Falantar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2009, 11:17 AM

Tags for this Thread

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