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!!