ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macros (https://www.excelbanter.com/excel-programming/357033-macros.html)

Biker Bob

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!

Tom Ogilvy

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!



All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com