Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Making a sheet active How-To ...
Desired behaviour: Activate a particular sheet in a workbook based on its name. I've been using the search feature of this forum and found this code snippet. Sub test() For Each sht In ActiveWorkbook.Worksheets "Your code" Next sht End Sub So, to accomplish the above desired behaviour...- wolfess
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Object Model question (a How-To)
How do you change the tab name (I would think it would be called a caption or text) on the .activesheet object? I've looked for an hour now up on MSDN and the only thing I have found is some articles referencing the tab object, but I'm not sure that is the object I want to use. I have a master...- wolfess
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
