#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
weird saving of a document with macros resulting with macros being transfered to the copy alfonso gonzales Excel Programming 0 December 12th 04 09:19 PM
Macros inside macros, and pasting into macro code. pagelocator[_2_] Excel Programming 1 November 24th 04 09:11 AM
convert lotus 123w macros to excel macros rpiescik Excel Programming 1 September 18th 04 01:35 PM
Open workbook-macros enabled, opening another with macros George J Excel Programming 5 September 17th 04 02:07 PM
Suppress the Disable Macros / Enable Macros Dialog Shoji Karai Excel Programming 5 September 24th 03 03:10 AM


All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"