Hi,
I try that one, but it show compile error, basically I want to change
the border colour in to thick black or red. Even I don't want to
colour the entire cell.
Thanks and Regards
SATISH
On Oct 8, 9:07 am, Mahesh parab mahes...@gmail.com wrote:
Hi
Try:
Sub Mtest()
Dim found As Range
Software
dguille...@gmail.com
-Original Message-
From: satish
Sent: Monday, October 10, 2011 6:34 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Want to Highlight find Cell
Hi,
I try that one, but it show compile error, basically I want to change
the border colour in to thick
: Monday, October 10, 2011 6:34 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Want to Highlight find Cell
Hi,
I try that one, but it show compile error, basically I want to change
the border colour in to thick black or red. Even I don't want to
colour the entire cell.
Thanks
Look down this email to see where to delete and then add my mod
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: satish
Sent: Monday, October 10, 2011 9:04 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Want to Highlight find Cell
I am
-
From: satish
Sent: Monday, October 10, 2011 9:04 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Want to Highlight find Cell
I am not expert, could you please let me know where this program has
to be placed, If you give me the full modified content that will be
useful
Send your file
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: satish
Sent: Monday, October 10, 2011 9:41 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Want to Highlight find Cell
I tried Don,
I could not able to make it, could you
Hi
Try:
Sub Mtest()
Dim found As Range
Dim m As String, Temp As String
Dim count As Integer
Dim ws As Worksheet
count = 0
m = InputBox(prompt:=Enter value for search, Title:=Excel Find)
For Each ws In ActiveWorkbook.Worksheets
Set found = ws.Cells.Find(What:=m, LookIn:=xlValues, lookat:=xlPart)
Dear all,
Sometimes I work with large data, if i want to find some data,
normally I type the key word in find option, I want to highlight the
cell with some colour to view it clearly, which cell is highlighted.
Normally it goes to cell but i have some problem ( eye sight).
Thanks in advance
--