Excel Grouped Graphics Numbering in VBA
 

Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer
control the numbers assigned to grouped graphics? How?

Excel Grouped Graphics Numbering in VBA
 

Flintstone,
If it helps, you can this:
ActiveSheet.Pictures.Insert("C:\My Pics\Sample.jpg").Select
Selection.Name = "picOne"
Then when looping through a collection/group, you can check the name
property to see what you should do

NickHK

"Flintstone" wrote in message
...
Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer
control the numbers assigned to grouped graphics? How?

Excel Grouped Graphics Numbering in VBA
 

Thanks for that Nick, I'll give it a try.

I would still like to understand how the numbering system
works and how it can be controlled so if there is anyone
with references or who knows how it works I would still
like to get the info.
-----Original Message-----
Flintstone,
If it helps, you can this:
ActiveSheet.Pictures.Insert("C:\My
Pics\Sample.jpg").Select
Selection.Name = "picOne"
Then when looping through a collection/group, you can
check the name
property to see what you should do

NickHK

"Flintstone" wrote
in message
...
Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer
control the numbers assigned to grouped graphics? How?


.

Excel Grouped Graphics Numbering in VBA
 

Flintstone,
Sorry, misunderstood you, I think.

Each shape/group number is incremented by each time:
"Line 1"
"Rectangle 2"
Group 2 above "Group 3"

"Oval 4"
"Rectangle 5"
Group 2 above "Group 6"

Group 2 groups "Group 7"

Does that help ?

NickHK

"Flintstone" wrote in message
...
Thanks for that Nick, I'll give it a try.

I would still like to understand how the numbering system
works and how it can be controlled so if there is anyone
with references or who knows how it works I would still
like to get the info.
-----Original Message-----
Flintstone,
If it helps, you can this:
ActiveSheet.Pictures.Insert("C:\My
Pics\Sample.jpg").Select
Selection.Name = "picOne"
Then when looping through a collection/group, you can
check the name
property to see what you should do

NickHK

"Flintstone" wrote
in message
...
Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer
control the numbers assigned to grouped graphics? How?


.