Line of code not translating from 2003 to 2007

Originally Posted by simjambra

I notice Calendar control is not there, is this one that should be?

No, don't fret

Sometimes pre 2007 files debug when run in 2007 because previously available libraries / controls are no longer available... the Calendar Control is a classic case in point (and often a culprit) given it does not exist in 2007 by default.

In this case the above is not an issue (nothing denoted as missing).


You didn't stipulate what the Debug was ... ie the error message itself ... can you ?

My next question would be that mentioned in the Italics previously - ie how is LastRow declared ?

If LastRow is declared as Integer and the last used cell in Col N appears after row 32767 you would generate a Debug (overflow) ... best to use Long rather than Integer (in 32 bit VBA Integers are converted to Longs "under the hood" so no gain in using Integer)