Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
had Tom help me previously with following command as part of larger code
activesheet.ChartObjects(1).Chart.Axes(xlValue,xlS econdary).TickLabels.Font.Name Book Antiqua This, as I understand it, depends on knowing which object you want to select. But if I am using '07 (in case it matters) and want the macro to 1) determine how many objects are on the page and the 2) go through each object one by one, and complete a set of steps, how would I do that? Additionally, if I were to want to not have it go through automatically and do each, what is the final command I can put on my code to say, effectively, "pick the next object on the sheet." Thx in advance. -- Boris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Object Selection | Excel Discussion (Misc queries) | |||
Selection with one object | Excel Programming | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
Object Type of a selection... counting rows in a selection | Excel Programming | |||
Selection object in Excel 2002 | Excel Programming |