Macro Record problem

[Kash]

I am trying to record a macro, but it is not getting recorded properly. How
to rectify this?

eg. of my recorded macro

 

[Jacob Skaria]

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

 

[Kash]

I'm getting error while recording macro..

 

[Jacob Skaria]

What's the error?

 

[Kash]

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?

 

[Jacob Skaria]

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?

 

[Dave Peterson]

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]

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

Did you try uninstalling xl2010?

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