Macro Record problem
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 |
Macro Record problem
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 |
Macro Record problem
I'm getting error while recording macro..
|
Macro Record problem
What's the error?
-- Jacob (MVP - Excel) "Kash" wrote: I'm getting error while recording macro.. |
Macro Record problem
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? |
Macro Record problem
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? |
Macro Record problem
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 |
Macro Record problem
--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 |
Macro Record problem
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 |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com