Add shape without selecting worksheet or cell

[rgarber]

Hi
The following code works well in circling [actually an oval around] a cell - but I haven't been able to figure out how to add a shape without selecting the sheet and a cell. I'm assuming this is possible and I'm missing the obvious. Any help would be appreciated. Thanks.
Richard

Please Login or Register  to view this content.

[shg]

Welcome to the forum.

One way:

Please Login or Register  to view this content.

My, what large variable names you have ...

[rgarber]

Thanks - works perfectly! I am new at programming and find I'm able to be more descriptive with the long variable names. I do get a little carried away at times.

Thanks again.
Richard