Dev,
You can't show that apart from on the ActiveSheet.

NickHK

"Dev" ...
I mean if cells are in different worksheet(s)...

"Dev" wrote:

but it's not wokring for discontigious cells. I may have my cells which
has
special data discontigiously...

"Tom Ogilvy" wrote:

selection.copy

until something happens that clears the clipboard, you should have the
marquee

--
Regards,
Tom Ogilvy

"Dev" wrote:

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to
right
click - when user clicks on that menu items then I want to show all
the
cells (with marching ants around) that has special data. Is this
possible to
do programatically?

Thanks in advance!!