Hi Geoff,
Yes, I did do the debug using F8 : as the "translation" sheet is being parsed, you can see the values of ENname and FRname being updated just as they should.
For instance:
- WORKS CORRECTLY:
ENname="Brussels"
FRname="Bruxelles"
Worksheets("Geo").Columns("I:L").Replace _...
Hi there,
I have a excel spreadsheet with 2 sheets:
- "Geo" sheet: containing name of places (columns I to L in French and columns M to P in English)
- "Translation" sheet: contain the translation between French and English (Column A=name in English; column B=name in French)
My goal is to use...
Hi guys!
Hope you can help me with this one:
- I have a huge MS Access table.
- One of the columns is free text; let's call it "FreeTextColumn".
- Each cell in FreeTextcolumn is free text, and contains either 0 or 1 email address.
- If there is 1 email address, I need to extract it from the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.