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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wolfess
-
Making a sheet active How-To ...
Both the Sheets("SheetName").Activate and the ActiveWorkbook.Worksheets("Sep 05").Activate methods work. Direct access via a method is always better than enumerating an object. I have put in a request for the book that was suggested earlier that lays out the Excel Object Model -- that will...- wolfess
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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)
I want to thank all three of you for your help. And, not to be so much of a bug here on the forum, do any of you know of a good reference that lays out all of the excel object model objects with methods and properties easily identified? I don't mind studying and it appears I'll be doing a lot...- wolfess
- Post #5
- 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)
