Creating macros in Excel

's Computer Specifications

I need help with creating a function within excel worksheet. Which
will look for a keyword "Summary" and if it will find it then I would
like to highlight the entire row with green color.

Thank you

's Computer Specifications

Sub virina()
Set r = ActiveSheet.UsedRange
For Each rr In r
If InStr(rr.Value, "Summary") <> 0 Then
rr.EntireRow.Interior.ColorIndex = 10
End If
Next
End Sub

--
Gary''s Student - gsnu200717

"(E-Mail Removed)" wrote:

> I need help with creating a function within excel worksheet. Which
> will look for a keyword "Summary" and if it will find it then I would
> like to highlight the entire row with green color.
>
> Thank you
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
EXCEL 2007 CREATING A MACROS	FIEGEHENK	Microsoft Excel New Users	2	30th Jun 2009 12:31 AM
creating macros in excel	=?Utf-8?B?cnlhbnpvbzA2?=	Microsoft Excel Misc	1	15th May 2007 07:43 PM
Creating add-ins from Excel 4 macros	=?Utf-8?B?R3JhaGFt?=	Microsoft Excel Programming	8	18th Jul 2006 06:02 PM
creating excel macros	=?Utf-8?B?RGljaw==?=	Microsoft Excel Worksheet Functions	0	2nd Jun 2006 06:56 PM
Creating a .EXE to run excel macros	Hemanth	Microsoft Excel Programming	4	6th Jan 2006 06:08 PM