How do you select a row
 

I am trying to write a macro whereby I want to find "*" in column B an
then select and format that row to be bold.

How do you do this?

Thanks
Kulbir Sing

--
KulbirSing
-----------------------------------------------------------------------
KulbirSingh's Profile: http://www.excelforum.com/member.php...fo&userid=1562
View this thread: http://www.excelforum.com/showthread.php?threadid=27166

How do you select a row
 

A simple mod of findnext available in HELP index. NO need to select.

Sub findstar()
With activesheet.columns(2)
Set c = .Find("*", LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.Font.Bold = True
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address < firstAddress
End If
End With

End Sub


--
Don Guillett
SalesAid Software

"KulbirSingh" wrote in message
...

I am trying to write a macro whereby I want to find "*" in column B and
then select and format that row to be bold.

How do you do this?

Thanks
Kulbir Singh


--
KulbirSingh
------------------------------------------------------------------------
KulbirSingh's Profile:
http://www.excelforum.com/member.php...o&userid=15621
View this thread: http://www.excelforum.com/showthread...hreadid=271666