Find Range Location of a Shape Object
 

Is it possible to show the location of a Shape Object by cell reference?
That is, I know I can return the sheet that a shape is on. But I want to
know:

1) What cells is it nearest
2) What cells does it cover?

Thanks

EM

Find Range Location of a Shape Object
 

I asked a similar question earlier this year:

http://groups.google.com/group/micro...cd d139a31f7e
--
Gary''s Student - gsnu200819


"ExcelMonkey" wrote:

Is it possible to show the location of a Shape Object by cell reference?
That is, I know I can return the sheet that a shape is on. But I want to
know:

1) What cells is it nearest
2) What cells does it cover?

Thanks

EM