Selecting multiple ranges in a macro
Posted on 2000-04-21
I use a speradsheet to track daily data. I have around 20 rows and a new column for each day. I want to select a row 1 cell, in today's column, and start a macro. The macro should select cells in rows 8-12 and 17-25 (just in today's column). The cells will then be copied and pasted into another sheet.
I'm struggling with this;
The range will be different each day and how do you tell it to select 2 ranges?