Macro Record problem
in [Programming]
|
Prev: Need help in highlighting the cell color in VBA
Next: how to open a password protected powerpoint file by Excel
From: Kash on 2 Jun 2010 00:47 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
From: Jacob Skaria on 2 Jun 2010 00:56 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
From: Kash on 2 Jun 2010 02:06 I'm getting error while recording macro..
From: Jacob Skaria on 2 Jun 2010 02:09 What's the error? -- Jacob (MVP - Excel) "Kash" wrote: > I'm getting error while recording macro..
From: Kash on 2 Jun 2010 02:16
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? |