Re: $$Excel-Macros$$ A macro to parse a wordlist in Excel

with this task! On May 14, 8:10 am, ashish koul wrote: > what in case of address > > which one it should pic > > absolute address access address > > > > > > On Fri, May 13, 2011 at 8:42 PM, Ivaylo wrote: > > Hi Ashish, > > > Thank you very

Re: $$Excel-Macros$$ A macro to parse a wordlist in Excel

.Range("a65356").End(xlUp).Row > > If swa <> i Then > > If InStr(1, Application.WorksheetFunction.Trim(Cells(swa, 1)), > Application.WorksheetFunction.Trim(Cells(i, 1))) > 0 Then > > z = z & Application.WorksheetFunction.Trim(Cells(swa, 1)) & "|&quo

$$Excel-Macros$$ A macro to parse a wordlist in Excel

Hi to all VBA gurus, I need help with an Excel macro which can do the following: I have a long list of dictionary headwords in column A (sorted alphabetically), something like this: abnormal termination abnormal abort about absolute absolute address absolute code accent access access address acc

$$Excel-Macros$$ Help - macro messes up the cell formating

Greetings, I need help with a macro. I use this macro in Excel 2007: Sub ReplaceTags2() For Each c In ActiveCell.CurrentRegion.Cells c.Value = Application.WorksheetFunction.Substitute(c, "", Chr(10) & Chr(10)) Next End Sub My data contains the markers , which I want to replace with line