Macro Record problem

  • Thread starter Thread starter Kash
  • Start date Start date
K

Kash

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

eg. of my recorded macro
 
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
 
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?
 
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.
 
--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?
--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
Click to expand...
 
Back
Top