VBA Dynamic Replace Function
-
- NewLounger
- Posts: 17
- Joined: 17 Mar 2016, 20:09
Re: VBA Dynamic Replace Function
this is so strange
Last edited by datajunkie on 18 Mar 2016, 13:38, edited 1 time in total.
-
- NewLounger
- Posts: 17
- Joined: 17 Mar 2016, 20:09
Re: VBA Dynamic Replace Function
Now I am beyond confused. See the attached excel and word. When I do a control Find of A3 it finds it in multiple cells. The attached word has the HTML code from column D and when I do a control find of A3 in the word it finds the value. Also, I added the search function for row A3 and it does find the value within the cells...
There is something weird going on here.
There is something weird going on here.
-
- NewLounger
- Posts: 17
- Joined: 17 Mar 2016, 20:09
Re: VBA Dynamic Replace Function
just to make this weirder. On my mac when I do a control find it finds the values in A3. When I bring the file to a PC it does not find the string in A3. I have no idea what the hell is going on now.
-
- Administrator
- Posts: 78658
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA Dynamic Replace Function
I won't be able to look at this until tomorrow. Perhaps someone else will jump in before that.
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 17
- Joined: 17 Mar 2016, 20:09
Re: VBA Dynamic Replace Function
No worries. Would love to know your thoughts when you have a second to check out. It's just beyond peculiar. The only thing I can think is that the length of the fields where I'm trying to replace the text in is too long? but that really doesn't make sense.
-
- NewLounger
- Posts: 17
- Joined: 17 Mar 2016, 20:09
Re: VBA Dynamic Replace Function
Found a solution - used the substitute function and had the function reference the cell above :)
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: VBA Dynamic Replace Function
Hi Dan,
I see you have resolved it , but for future reference, it doesn't really help your cause if you delete the attachments all the time. I'm trying to jump in and help resolve your query and I click the links to your attachments and it does not exist anymore. It would be better to desensitize a small example that we can all use and reference than to keep deleting an actual copy of your file. Please take the time to create something that does not need to be deleted so other loungers can have an opportunity to help resolve any future queries you might have down the line. TX.
I see you have resolved it , but for future reference, it doesn't really help your cause if you delete the attachments all the time. I'm trying to jump in and help resolve your query and I click the links to your attachments and it does not exist anymore. It would be better to desensitize a small example that we can all use and reference than to keep deleting an actual copy of your file. Please take the time to create something that does not need to be deleted so other loungers can have an opportunity to help resolve any future queries you might have down the line. TX.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- NewLounger
- Posts: 17
- Joined: 17 Mar 2016, 20:09
Re: VBA Dynamic Replace Function
sorry about that - the solution ended up being using the substitution function - I will provide an excel file with solution for other's reference.