Dear Mr Bill Jelen and Ms Tracy Syrstad,
*
I purchased your book ‘VBA and Macros for Microsoft Excel’ recently, and have been reading the pages whenever time permits me to do so. I find it resourceful, but too voluminous – but I guess understanding how to program Excel is that of a huge thing.
*
From the reading of your book, I am trying to record/write a simple VBA code to allow me to move from one worksheet to another worksheet within the same workbook; but have failed to comprehend why it cannot work. An error ‘1004’ message kept popping up and I can’t seem to figure out what has gone wrong. I am wondering if you can help me out here. The gist of the code is as follows :
*
Sub Macro1( )
'
' Macro1 Macro
' Macro recorded 30/03/2010 by WCL
'
*** Dim MyValue, Var1, Var2
*** Range("E2").Select
*** Range("D3").Select
*** Var1 = Range("E2")
*** Var2 = Range("D3")
*** MyValue = Var1 & Var2
*** Application.Goto Reference:=MyValue
*** Range("A1").Select
*** ActiveWindow.NewWindow
*** Windows.Arrange ArrangeStyle:=xlVertical
*** Sheets("Summary").Select
*** Windows("WCLworkbook.xls:1").Activate
*** With ActiveWindow
******* .Width = 470
******* .Height = 473.25
*** End With
End Sub
*
I am a novice when it comes to VBA programming – I use Excel mainly to tabulate my monthly expenses.
*
I will really appreciate your assisting me in the above.
*
I purchased your book ‘VBA and Macros for Microsoft Excel’ recently, and have been reading the pages whenever time permits me to do so. I find it resourceful, but too voluminous – but I guess understanding how to program Excel is that of a huge thing.
*
From the reading of your book, I am trying to record/write a simple VBA code to allow me to move from one worksheet to another worksheet within the same workbook; but have failed to comprehend why it cannot work. An error ‘1004’ message kept popping up and I can’t seem to figure out what has gone wrong. I am wondering if you can help me out here. The gist of the code is as follows :
*
Sub Macro1( )
'
' Macro1 Macro
' Macro recorded 30/03/2010 by WCL
'
*** Dim MyValue, Var1, Var2
*** Range("E2").Select
*** Range("D3").Select
*** Var1 = Range("E2")
*** Var2 = Range("D3")
*** MyValue = Var1 & Var2
*** Application.Goto Reference:=MyValue
*** Range("A1").Select
*** ActiveWindow.NewWindow
*** Windows.Arrange ArrangeStyle:=xlVertical
*** Sheets("Summary").Select
*** Windows("WCLworkbook.xls:1").Activate
*** With ActiveWindow
******* .Width = 470
******* .Height = 473.25
*** End With
End Sub
*
I am a novice when it comes to VBA programming – I use Excel mainly to tabulate my monthly expenses.
*
I will really appreciate your assisting me in the above.
