| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Macro format selection
Hi here is part of my macro,
Selection.AutoFilter Field:=3, Criteria1:="FC" Rows("2:51").Select Range("A51").Activate Selection.Font.ColorIndex = 5 My data is different every day. so Rows("2:51").Select -------------- this could be from 2:40 or 2:75 Range("A51").Activate How do I write it so that it will select only Criteria1:="FC" Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
| Drop down selection auto format | Excel Discussion (Misc queries) | |||
| Dynamic chart format & data selection? | Charts and Charting in Excel | |||
| Edit, Format random selection | Excel Discussion (Misc queries) | |||
| Format of autofilter selection list. | Excel Discussion (Misc queries) | |||
Hybrid Mode
