+ Reply to Thread
Results 1 to 3 of 3

Unable to dictate which row to paste search results in

  1. #1
    Registered User
    Join Date
    11-22-2012
    Location
    Wellington, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    Unable to dictate which row to paste search results in

    Hi there,

    The attached search macro is searching in 'Records' and returning the results in 'Search Results'. However, the search results are pasted in B2 and below. I want them to start in B5, but am unable to do so. The following is the limited part of the code:
    Copy Sheets("Search Results").Range("b" & Rows.Count).End(xlUp).Offset(1)

    Can anyone help? Thanks in advance.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Unable to dictate which row to paste search results in

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    11-22-2012
    Location
    Wellington, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Unable to dictate which row to paste search results in

    That's fantastic protonLeah, exactly what I needed - thanks for the prompt reply.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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