HELP!! MY EXCEL has GONE CRAZY!!!

H

hce

Dear All

I was not able to run a macro which I have created days ago using Exce
2003. It worked perfectly when I used it few days ago... but now it'
not working. However, if I use the macro on another computer also usin
Excel 2003, the macro worked perfectly.

The error was that "Activesheet.Paste" is not valid... and one othe
command which was to delete the row...

I used to have problems with running macros in Excel 2003 if the macr
is created using versions before Excel 2003. However, this time, th
macro is created using Excel 2003 and on my computer... and it worke
for the first few times and suddenly it don't work on my computer bu
on other computers...

I have also checked everthing like the format needed to run the macro
etc but found no mistakes... Also, if there was a mistake, the macr
couldn't have work perfectly in other computers...

This problem occurred after I installed some Windows updates yesterda
so could this be the root of the problem...? If so, how can I solv
it?

Cheer
 
H

hce

HI Frank

Nope... I have checked everything... in fact i ran the macro on tha
same file in another computer and it worked fine... but when i tried i
again in my own computer... it will crash... i dun understand how ca
the command Activesheet.Paste which is such a simple command canno
work in VB...? In fact when i tried to record a macro in Excel - jus
copy and paste... when I looked at the code for this copy and paste..
the paste command is missing... is there something wrong with my v
editor...?

cheer
 
F

Frank Kabel

Hi
you may check in the VBE editor that the reference to the Excel object
librarty is set (goto 'tools - References)
 
Top