Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-19 Thread Priyanka Jaswal
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

Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-11 Thread Ashish Koul
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

Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-11 Thread Priyanka Jaswal
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

Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-11 Thread Ashish Koul
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

Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-11 Thread Priyanka Jaswal
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

Re: $$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-11 Thread Ashish Koul
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

$$Excel-Macros$$ Find a same word in the worksheets multiple times using vba code

2016-04-10 Thread Priya
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 and I cant set a code specific to a word. The issue I am getting is that I only get one row from