how to get marching ants in Excel programmatically

[Dev]

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

 

[Tom Ogilvy]

selection.copy

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

 

[Dev]

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

 

[Dev]

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

 

[Tom Ogilvy]

Looks like you are out of luck unless you are willing to program it from
scratch.


maybe blinking cells?

 

[Dev]

can we acheive blinking cells for cells across different worksheets? if so,
how to do it? thanks!!

 

[Tom Ogilvy]

http://tinyurl.com/gu6p2

there is no reason you couldn't write your code to make cells on other
sheets blink, but I am not sure what purpose it would serve if no one can
see them blinking.