PDA

View Full Version : select ranges on different worksheets



fraser5002
11-18-2008, 06:12 AM
Hi how do i select different ranges from 2 or more worksheets

im using this code to select multiple ranges on one sheet but how do i do it for multiple worksheets

range(A1:C5,F3:H5).select

thanks

Jan Karel Pieterse
11-18-2008, 07:46 AM
You can't select multiple ranges which are on different sheets.
What are you trying to do?