Search results
-
W
Need to pull max price out of paragraph
That works great!! I did not have the Option Compare Database in the declarations. Thank you so much. I can't even describe how much I appreciate your help. -
W
Need to pull max price out of paragraph
My apologies bwellbor and vbaInet, I just realized I'm an idiot. :D The reason my query isn't working is due to some entries having lower case "k" and some upper case "K". Pretty much an exhaustive list of values I need to pull would be: $10 / $100 / $1k / $1K / $1000 / $1,000 / $10000 /... -
W
Need to pull max price out of paragraph
One other question if you have time. I just realized my original query is setup to pull $1k, then swap the k with ",000". But not for $10k senarios. I tried to add an "OR" at the beggining and change the +1 to +2, but that didn't seem to work. Any suggestions? Thanks so much as I'm still... -
W
Need to pull max price out of paragraph
Wow, it works great!!! Thanks so much for your help. This is perfect. -
W
Need to pull max price out of paragraph
So far it finds the "$", then returns the string. Occasionally there is a $5k, so it also changes it to $5000 and returns it. Now I need help if there are multiple values (always preceded by a "$") and pulling the max. Thanks in Advance, as I can't seem to figure this one out. Public...