How Do I (Macro Function)?

S

Swivel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Saving a range for later reference 0
How can I assign button/buttons to XL 2007 by Macro for different 0
How do I create a drop down box within a drop down box? 1
IF function that searches a range of cells for data and provide tr 2
CLEAN function - macro?? 10
Concatenate Macro 5

Top