Thread: macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default macros

In excel 2003 or 2002, do Edit=find and specify your format.

If you need a macro, turn on the macro recorder while you do it manually.

If you have an earlier version, you would have to have your macro loop
through all your cells and check for a matching condition.

--
Regards,
Tom Ogilvy


"Biker Bob" wrote:

How do I write code to be able to select a cell, row, etc. of your choice? Is
there a wildcard symbol?
An example would be to record a macro to select a range of cell with
specific formating that you want to apply to a range of cells of your choice.
Thanks!