here's what I want to do:
1. search for a field on an Excel Spreadsheet
- I have done this - no problem
2. add one row immediately below this field
I've recorded a basic macro and it's come up with this:
But I want the Range to be two rows down from where the search ends up - as the field I'm searching for might not always be in the same place.
In other words I want the selection to be relative to the current position rather than always being B8.