Hey guys,
I'm kind of new to writing macros and things have been going fine so far, but I've hit a problem that the internet doesn't seem to help me out with, so hopefully someone here has the knowledge!
I want to save a file as a cell-defined name to an area which is also cell define. For example, save as:
J:\Reports\F4\G10.xls
Where F4 and G10 are obviously cell references.
I can get it to save as the text in G10 to its current location, but I've no idea how to go about changing the F4 section.
Any help would be greatly appreciated
Thanks,
Jaff
Bookmarks