Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
FWIW, I don't look at TopLeftCell and BottomRightCell, but compare left,
top, right, bottom of each object with that of the range, and set a flag against the object index if inside. That's a good idea. I was using the Intersect (and Offset(-1,-1) for the BottomRightCell) then testing the result for Is Nothing. less than 0.1 sec I'm performing quite a few operations in addition to this and I'm noticing a slight latency. I haven't measured anything yet, but I'm just looking through my code to see where i might be able to trim it up. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shape Range | Charts and Charting in Excel | |||
detecting range of spreadsheet | New Users to Excel | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
align a picture/shape in a Range! | Excel Programming | |||
detecting shape clicked on | Excel Programming |