Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macros inside macros, and pasting into macro code. | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |