ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How Do I (Macro Function)? (https://www.excelbanter.com/excel-worksheet-functions/5564-how-do-i-macro-function.html)

Swivel

How Do I (Macro Function)?
 
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.

Don Guillett

a bit more specific about the destination?

--
Don Guillett
SalesAid Software

"Swivel" wrote in message
om...
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.





All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com