I just noticed that you said the number is a date. If possible, if you could attached a spreadsheet for testing, it would help.
possible alteration to
Could work if you experince problems, but I haven't tested it.
Very little testing was done with this code on a spreadsheat created using your example.
I think it will work just fine. Try this.
NOTE:This code assumes the following.
All of you numbers are in column A
Colum A contains no blank cells before the end of the sheet
You have a header on your worksheet
to make this work. open your sheet click on tools, option, visual basic editor. right click on thisworkbook and select insert modual. Past the code in there. press F5 to run the code on the sheet that you opened.
if you want to run this on a workbook with multiple sheets, use the following.
IMPORTANT NOTE: THIS CODE MIGHT ENCOUNTER PROBLEMS DEPENDING ON WHAT IS CONTAINED IN YOU HEADER. THIS WAS TESTED ON A SHEET WITH A BLANK LINE ON ROW 1.
Bookmarks