Prevent overwriting a file
Thank you
I get a Subscript out of range error with the code below highlighted. I
thought the problem might be that the type of file was not indicated (in
this case xlsm) so I tried adding before the last quote mark but I still got
the same error.
FileName = "P:\AA Exception\ " _
& Worksheets("ReliefBoard").[B3].Value _
& ", " & Worksheets("Relief Board").[D3].Value _
& "_Exception Sheet"
|