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.
Bookmarks