File name based on cell value not working

Hi all

For some reason the file name is not working with a reference to cell H6. Cell H6 is a date value.

If anyone could help that would be greatly appreciated.

Thanks

Please Login or Register  to view this content.

try Range("H6").Value

GP

Hey mate

Thanks for the response. It hasn't worked and when it goes to the de-bugger it highlights the following paragraph in yello.

not sure if t

You are welcome. You will also need to specify sheet. For example activesheet.range("h6").value. GP

hey mate

Still won't work.

Same issue again, highlights the following paragraph.

Please Login or Register  to view this content.

Hi again. Date value in cell H6 will need to be converted to a string (without "/" characters) to be valid as a filename.

That makes sense. Thanks heaps for your help!

Thanks a lot guys, worked a treat.