Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Setting the magnification to a range of cell's | Excel Discussion (Misc queries) | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |