after match wht u wanna do highlight cell ?
On Sun, Apr 10, 2016 at 10:04 PM, Priya wrote:
> Hi
>
> I am writing a code to look for same word in the worksheets , where ever
> it is written in the worksheet, (basically need all the rows where that
> particular word is written ). The data is huge
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Position: IBM WCM Lead Developer/Architect*
*Location: Dallas, TX.*
*Dutation: 6+ Months*
*Job Description:*
ü Minimum 6+ years of experience on *IBM Web Content Management(WCM)*
ü WCM specialist/prog
I want to highlight that particular word so for example if there is a word
retail in multiple columns and rows it should be highlighted with yellow
color everywhr , only that word not a cell row or column, thanks
On Monday, April 11, 2016, Ashish Koul wrote:
> after match wht u wanna do highlig
Sub sample()
'https://msdn.microsoft.com/en-us/library/office/ff839746.aspx
Dim wordtofind As String
wordtofind = "apple"
With Worksheets(1).UsedRange
Set c = .Find(wordtofind, LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.Interior.Col
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title : Edifecs Developer.*
*Location: Chattanooga, TN and Windsor, Connecticut*
*Duration: 6+ Months*
JD:
· Minimum 5-6 years of relevant experience in Healthcare EDI,
Edifecs.
· Strong
In the below code , a word apple has been written , in my sheet i cant
define words, it consists of 1000 words and i cant put any specific word,
is there any way of to put it across like
*Dim wordto find as string wordtofind=*" "
, thanks
On Monday, April 11, 2016, Ashish Koul wrote:
> Sub sampl
Can anyone pls help me into this...
On Apr 4, 2016 2:57 PM, "Secret Shot" wrote:
> Dear Experts,
>
> I have some text in a cell like "Date Range: 3/31/16 - 3/31/16"
>
> I want to extract the date in a another cell like date not as text only.
>
> Can any one help me with any dynamic formula which
Dear Experts:
In the attached spreadsheet, I have an array formula which I would like to
increase its dynamics. Currently, cells C7 and C8 require exact matches for
"term", but is it possible to make the formulas in C7 and C8 return results
for any "term" value above 12 just as it would return
paste words in sheet2 and change range as per ur requirement
Sub loop_word()
Dim cl As Range
'
For Each cl In Sheets("Sheet2").Range("a1:a2")
Call find_word(cl.Value)
Next
End Sub
Sub find_word(wrd)
'https://msdn.microsoft.com/en-us/library/office/ff839746.aspx
With Worksheets("Sheet1").Us