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