Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: VBA code not letting you switch sheets

    I've noticed that you cannot select cells from different sheets in successive lines, you have to do it in two moves, a la:

    Sheet("A").select
    Sheet("B").select
    Range("A1").select


    instead of just:

    Sheet("A").select
    Sheet("B").Range("A1").select


    anyone else know if this is just how it is or is it cause there's some other problem causing this ?

    C

  2. #2
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    Hi,

    Try this:

    Code:
    With Sheet("A")
       .Range(A1).Select
    End With
    Why do You need to select a range?

    Kind regards,
    Dennis
    Kind regards,
    Dennis

Posting Permissions

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