View Full Version : Find shapes in sheet
nungaorae
03-24-2008, 09:28 AM
Use VB6 call excel.application.
Want command to find group shape in sheet for get max num of shape.
thank you for helping.
: pray2:
Bob Phillips
03-24-2008, 09:33 AM
Perhaps
For Each shp In ActiveSheet.Shapes
c = c + 1
Next shp
MsgBox "Ther are " & c & " shapes"
nungaorae
03-24-2008, 09:57 AM
if have shapes in sheet following :
Group 1,Group 2,Group 3, Group 5,Group 10
want max number of shapes
Result => 10
please example code
thank you
:friends:
Bob Phillips
03-24-2008, 10:37 AM
Don't understand the question.
grichey
03-24-2008, 11:57 AM
=max([range]) ???
is Group 1-10 the names of your sheets?
is it the name of the shapes?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.