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
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
Maybe look at Tools>References in the VBIDE and see i any item has MISSING in the text, if so, uncheck it
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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:
[VBA]
dim CurrentCell as Range
CurrentCell = Sheets("Data").range("s2")
[/VBA]
GComyn
Because you have to use Set with object variables.Originally Posted by gcomyn