Hi Ashish,
I am experiencing an issue with my macro file. There are 5 columns and 397
rows in my master worksheet.
So i have created a macro file placing a search button in the one of the
worksheet . Whenever a word is type and we hit search it brings us the
result on the new worksheet, picking t
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
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
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
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
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
