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:

Range("B8").Select
Selection.EntireRow.Insert

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.

Help please?