Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try the below....
Sub Macro() Dim varFound As Variant, varSearch As Variant, strAddress As String varSearch = "Nr. Crt." ActiveSheet.Range("A:A").Font.Bold = False With ActiveSheet.Columns(1) Set varFound = .Find(varSearch, LookIn:=xlValues) If Not varFound Is Nothing Then strAddress = varFound.Address Do varFound.Resize(, 10).Font.Bold = True Set varFound = .FindNext(varFound) Loop While Not varFound Is Nothing And _ varFound.Address < strAddress End If End With End Sub If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i need a macro to bold a row or a range in that row(A:J) if in column A the macro finds "Nr. Crt.". Can this be done? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alphabetically list of last names: BOLD, not bold | Excel Discussion (Misc queries) | |||
Alphabetically list of names BOLD and NOT bold | Excel Discussion (Misc queries) | |||
Bold | Excel Discussion (Misc queries) | |||
Bold Row if Col E is bold | Excel Discussion (Misc queries) | |||
Join bold and non-bold text in one cell | Excel Discussion (Misc queries) |