Trying to write the SaveAs location that a user selects to a Worksheet cell,
and to write ONLY the location without the filename used in Cell A22 & use it in a Variable.
I tried modifying code like this, http://software-solutions-online.com...aveasfilename/
but, still inelegant and not working for me. Any ideas?