Re: $$Excel-Macros$$ Want to Highlight find Cell

2011-10-10 Thread dguillett1
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

Re: $$Excel-Macros$$ Want to Highlight find Cell

2011-10-10 Thread satish
t; > > > > > -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 not expert, could you please let me know where this program has > to be

Re: $$Excel-Macros$$ Want to Highlight find Cell

2011-10-10 Thread dguillett1
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 not

Re: $$Excel-Macros$$ Want to Highlight find Cell

2011-10-10 Thread satish
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 com

Re: $$Excel-Macros$$ Want to Highlight find Cell

2011-10-10 Thread dguillett1
on Guillett SalesAid 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

Re: $$Excel-Macros$$ Want to Highlight find Cell

2011-10-10 Thread satish
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 wrote: > Hi > > Try: > > Sub Mtest() > Dim found As Range > Dim m As Str

Re: $$Excel-Macros$$ Want to Highlight find Cell

2011-10-08 Thread Mahesh parab
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:=xlPar

$$Excel-Macros$$ Want to Highlight find Cell

2011-10-07 Thread satish
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 --