Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have a range, Myrange. want to find each cell that has font size 18 in it.
I've been trying by using the find method. Can't get it right. I did the record macro thing and got: ---------- Range("A1:I1").Select With Application.FindFormat.Font .Size = 18 .Subscript = False End With Selection.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas,_ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,_ MatchCase:=False, SearchFormat:=True).Activate ------------- That's find on the worksheet but in VB it doesn't give me which cell it is found in so I try: -------- Dim Found as range, MyRange as Range Set MyRange = Range(Cells(1,1),Cells(1,18) MyRange.Select With Application.FindFormat.Font .Size = 18 .Subscript = False End With Set Found = Myrange.Find(What:="", After =... etc. etc. -------------- That produces an error. Help John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
change font size on screen, but prints in old size | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
Dropdown list for font size, font type and number formats | Excel Programming |