View Single Post
  #3   Report Post  
 
Posts: n/a
Default

Thanks Bernie.

I ultimately used a similar concept of searching the text string and
replacing the "x" with the cell contents in B12 but using the excel
worksheet function to accomplish the replace before passing the text
string to VBA to be evaluated. It worked, but not as elegantly as your
suggestion.

I would like to receive your sample file as I always learn from those
more gifted than I in the mysteries of VB. If your offer still stands,
please e-mail the file to:

Best regards,

GH