Consulting

Results 1 to 2 of 2

Thread: select ranges on different worksheets

  1. #1

    select ranges on different worksheets

    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

  2. #2
    You can't select multiple ranges which are on different sheets.
    What are you trying to do?
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •