jacksonworld
02-17-2008, 08:47 PM
Hi, I have an Excel challenge which I am spectularly failing to conquer.
I am also having great difficulty explaining the issue, so please bear with me. I hope someone will be kind enough to assist.
I have a series of cells, some of which are populated with dates; others of which are blank.
I am attempting to create a sub that will save the file, naming it according to the first non-blank value in the series - ie. a date.
To make it difficult, the date format in the cell is different from the filename date format.
I have attached a simple spreadsheet, as I realise my explanation is vague at best.
Thanks
I am also having great difficulty explaining the issue, so please bear with me. I hope someone will be kind enough to assist.
I have a series of cells, some of which are populated with dates; others of which are blank.
I am attempting to create a sub that will save the file, naming it according to the first non-blank value in the series - ie. a date.
To make it difficult, the date format in the cell is different from the filename date format.
I have attached a simple spreadsheet, as I realise my explanation is vague at best.
Thanks