Date and sequential serial numbers
Peter,
Is the Date cell formatted as date? What is in there? How have you declared
Startdato?
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Peter B" wrote in message
...
I have dimmed startdato as Integer and would simply add 1. The line that
doesnt work is this one:
Startdato = Range("Date").Value + 1
When I am trying to do this, I get the message:
"Run-time error '6':
Overflow"
Any suggestions?
Peter
|