VBA code not letting you switch sheets

ontheDB · #1 (**permalink**) 02-17-04, 11:37

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

Xl-Dennis · #2 (**permalink**) 02-17-04, 20:07

Hi,

Try this:

Code:

With Sheet("A")
   .Range(A1).Select
End With

Why do You need to select a range?

Kind regards,
Dennis

Internet Services

Web Development

Digital Marketing

Consumer Tech