I have a set of relatively simple macros that copy & paste data from 3
worksheets to a collection sheet. It goes to sheet1 & copies some data; then
screen2 etc etc
How do I select the range on a sheet without actually opening/closing that
sheet?