Problem using a variable to save a workbook as a .csv

[NackJich]

Hi there..
I have a script that calls several macros. I have it working to the point where it saves a variable in cell M1.
I'm trying to get it to save the workbook as a .csv using the M1 Variable. It will be a different value each time I run it.
I am seeing subscript out of range errors. Is this because the cell has no value when this macro tries to execute?

Please Login or Register  to view this content.

Thank you for your help.

[Roel Jongman]

I think so if cell M1 is empty then LIMSnumber will be empty, so you are trying to save a file without a filename..

Try testing LIMSnumber after you filled it. and let the sub end if there is no value

Please Login or Register  to view this content.

[NackJich]

Thanks Roel
That doesn't help. I made a new document with just the last macro. In M1 I typed Test. Now I'm seeing runtime error 9 subscript out of range Debug identifies: Sheets("csv").Select ??

[NackJich]

I solved it myself !!!!

Please Login or Register  to view this content.