Hi - I work regularly with macros but can't seem to get the contents of a cell (copied to the clipboard in a macro) to be pasted in the "SAVE AS" file name block. The contents of the cell change via an hlookup formula and the result is the filename. At present this is done manually but I am sure there is a macro that will use the contents of the clipboard to be the filename. Regards Mike100