PDA

View Full Version : VBA Error help please



Dan44
07-20-2010, 05:51 AM
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
07-20-2010, 06:56 AM
Maybe look at Tools>References in the VBIDE and see i any item has MISSING in the text, if so, uncheck it

gcomyn
07-20-2010, 07:59 AM
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
07-20-2010, 08:42 AM
then why use the 'set' command...

Because you have to use Set with object variables.