Hi,
I've tried to use "clearcontents" & "clear" but neither works the way I
wanted (I was using a 3rd party add-in, the add-in is disabled unless
"delete" is used. The down side is that would shift all my controls, too
(putting them all into the upper left corner). However, if I manually select
the whole worksheet, and press the delete key, that seems to work exactly
what I want (which is to clear all the contents, and yet leaving all the
controls where there are without shifting).

Please help
Jeff

Sounds like you need to try using SendKeys.

because if you record this action it uses ClearContents - and you say that
doesn't work.

--
Regards,
Tom Ogilvy




"Jeff" wrote in message
...
Hi,
I've tried to use "clearcontents" & "clear" but neither works the way I
wanted (I was using a 3rd party add-in, the add-in is disabled unless
"delete" is used. The down side is that would shift all my controls, too
(putting them all into the upper left corner). However, if I manually
select
the whole worksheet, and press the delete key, that seems to work exactly
what I want (which is to clear all the contents, and yet leaving all the
controls where there are without shifting).

Please help
Jeff