View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default macro for finding formatted cells

Post the code that works to find 1 cell.

--
Regards,
Tom Ogilvy


"LindaM" wrote in message
...
Columns D to F contain some cells with two diagonal borders forming an X.

I
want to find each formatted cell and enter "1" in it. I can do a simple
macro using Find but can't figure out how to get it to loop.

I'm fairly new to this sort of thing so really need a simple

"copy'n'paste"
type answer.

Thanks for your help
--
Linda M