Prev: Need help in highlighting the cell color in VBA
Next: how to open a password protected powerpoint file by Excel
From: Jacob Skaria on 2 Jun 2010 03:32
I have not come across with this error before. Post few more details so that
someone else can look into..

--Is Excel locally installed?
--Which version of excel do you use; and what is the OS. ?
--Was it working before or is it the same from the time of installation?
--Did you try repairing with the MSOffice CD?

--
Jacob (MVP - Excel)


"Kash" wrote:

> when I record a macro instead of
>
> Application.Goto Reference:="R1C4"
>
> i'm getting
>
> Application+Goto Reference .<= VB_VarUserMemIdR1C4VB_VarUserMemId
>
> why is this? and how to rectify?
From: Dave Peterson on 2 Jun 2010 07:05
Did you install xl2010?

I've read some posts that say that this can mess up the recorded syntax. That
post mentioned xl2002, but maybe it (xl2010) breaks the recording in other
versions, too.


Kash wrote:
>
> I am trying to record a macro, but it is not getting recorded properly. How
> to rectify this?
>
> eg. of my recorded macro
> ---------------------------------
>
> Range& VB_VarUserMemIdC4VB_VarUserMemId '+Select

--

Dave Peterson
From: Kash on 2 Jun 2010 10:02
--Is Excel locally installed? - Yes
--Which version of excel do you use; and what is the OS. ? - xl2003/xl2010 -
Windows7
--Was it working before or is it the same from the time of installation? - Yes
--Did you try repairing with the MSOffice CD? - Yes
From: Dave Peterson on 2 Jun 2010 11:26
Did you try uninstalling xl2010?

Kash wrote:
>
> --Is Excel locally installed? - Yes
> --Which version of excel do you use; and what is the OS. ? - xl2003/xl2010 -
> Windows7
> --Was it working before or is it the same from the time of installation? - Yes
> --Did you try repairing with the MSOffice CD? - Yes

--

Dave Peterson
First  |  Prev  | 
Pages: 1 2
Prev: Need help in highlighting the cell color in VBA
Next: how to open a password protected powerpoint file by Excel