Sam,
This is really great to know you got it working tht's the best thing..
The code for find and replace can be reduced to few lines.. but it's fine as
long as it serves the purpose. :)
Cheers,
Anish
On Tue, Jul 19, 2011 at 5:19 PM, Samuel Murray (Afrikaans translator) <
afrika...@gmail.co
Anish Shrivastava wrote:
> Anyways, I will give you another macro which will search in each cell on the
> sheet and if it finds a value then it will populate cells address at the
> begining for the text but this may lead to problem with formulas.
Your latest macro actually stops and gives me a
Samuel,
It was my assumption that your sheet would be the same as my example sheet
which I used for macro. However, I feel sorry that it didnt help you.
Anyways, I will give you another macro which will search in each cell on the
sheet and if it finds a value then it will populate cells address a
Anish Shrivastava wrote:
> Please have a look on the attached file. This might be helpful.
>
> I tried it only on one column since I dont know in how many columns you will
> have the data. If you could attach a sample sheet for your data, I can make
> it more feasible.
Thanks, Anish, for your a
Hello Samuel,
Please have a look on the attached file. This might be helpful.
I tried it only on one column since I dont know in how many columns you will
have the data. If you could attach a sample sheet for your data, I can make
it more feasible.
Let me know if it works, otherwise will try a d
G'day everyone
I have no experience in writing macros for Excel, although I do
regularly record and tinker with macros in Word. Please could someone
write the following macro for me :-)
Background: I'm a language translator and I need a macro that would
solve a problem I have with XLSX files. A
