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

While you try to record are you getting an error? OR Do you mean you want to
assign the range as a variable as below .

Sub Macro()
Dim strRange As String
strRange = "A1:B10"
Range(strRange).Select
End Sub


--
Jacob (MVP - Excel)


"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

I'm getting error while recording macro..

What's the error?

--
Jacob (MVP - Excel)


"Kash" wrote:

I'm getting error while recording macro..

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?

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?

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

--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

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