VBA Error help please

[Dan44]

Hi,

I keep getting this error when I try to run a macro in Excel 2003 on Windows XP... Can you help? I've uploaded a picture you can find it here - http://i29.tinypic.com/1zyxxjm.png

[Bob Phillips]

Maybe look at Tools>References in the VBIDE and see i any item has MISSING in the text, if so, uncheck it

[gcomyn]

One... I don't see where currentcell as dim'd... was it dim'd as a range?... then why use the 'set' command... just use:


dim CurrentCell as Range

CurrentCell = Sheets("Data").range("s2")


GComyn

[Aflatoon]

then why use the 'set' command...

Because you have to use Set with object variables.