I'm using version XL 97. Would like to know how to select a relative
range within a macro which is treating rows individually.

Eg: Have a spreadsheet with data in cells A1 to F1. Want to pick up
range B1:F1 and place elsewhere before moving to row 2 to re-perform.