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