VBA setting range in another sheet
 

I want to save the value in tab="Database" to a variable.

But I don't want to activate the sheet everytime, since this seems to slow
things down a lot.

So originally I was writing:

Sheets("Database").select
X = Range("F4").Value

But is there another way to set X=Range F4, without selecting the sheet?

Thanks

Good man!

X = Sheets("Database").Range("F4").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeff" wrote in message
...
I want to save the value in tab="Database" to a variable.

But I don't want to activate the sheet everytime, since this seems to slow
things down a lot.

So originally I was writing:

Sheets("Database").select
X = Range("F4").Value

But is there another way to set X=Range F4, without selecting the sheet?

Thanks

Dim X as Variant
x = worksheets("database").range("f4").value





Jeff wrote:

I want to save the value in tab="Database" to a variable.

But I don't want to activate the sheet everytime, since this seems to slow
things down a lot.

So originally I was writing:

Sheets("Database").select
X = Range("F4").Value

But is there another way to set X=Range F4, without selecting the sheet?

Thanks

--

Dave Peterson