if i want to call a sheet using something like:
is it possible to make it so that it selects the first sheet in the workbook, regardless of its name? or the second sheet regardless of its name etc; This current code fails every time i have a workbook with costum named sheets
Please Login or Register to view this content.
try this...
Sheets(1).Select 'this selects the first sheet.
That would be:
Please Login or Register to view this content.
Just a tip, there should be virtually no reason to "select" a sheet before doing something to it, and it slows your code down to a crawl. The macro recorder leads people to do that because people DO select sheets before acting on them, so the recorder records you doing that. But in VBA, it's not necessary, actually bad to do.
If you post more of your code we can assist you passing instructions directly to a worksheet withOUT selecting it first.
Last edited by JBeaucaire; 05-25-2010 at 01:30 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You can use- Where Sheet1 is the name of the worksheet in the Project explorer rather than the name on the tab.Please Login or Register to view this content.
Is that what you are asking?
that is my 2nd line of code. is there a way to switch the activesheet.range into selecting the correct sheet all in one line?Sheets("Sheet1").Select
ActiveSheet.Range("$A$1:$E$13513").AutoFilter Field:=1, Criteria1:="mol/l"
Yep:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks