mickygoalie
New Member
- Joined
- Nov 23, 2010
- Messages
- 18
Hi
I don't know about writting Macros, but I have recorded the following one.
Sub Change()
'
' Change Macro
'
'
ActiveCell.FormulaR1C1 = "=April!RC"
Range("B5").Select
Selection.AutoFill Destination:=Range("B5:B22"), Type:=xlFillDefault
Range("B5:B22").Select
Selection.Copy
Range("F5").Select
ActiveSheet.Paste
Range("J5").Select
ActiveSheet.Paste
Range("N5").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=18
Range("B29").Select
ActiveSheet.Paste
Range("J29").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=21
Application.CutCopyMode = False
End Sub
However rather than using the line below which looks at the sheet named April, I would like it to look at the sheet to the left of the active sheet.
ActiveCell.FormulaR1C1 = "=April!RC"
I'm sure this is really easy, but I just don't know anything yet.
Can anyone recommend a good beginners guide to help me learn about VBA?
Thanks
I don't know about writting Macros, but I have recorded the following one.
Sub Change()
'
' Change Macro
'
'
ActiveCell.FormulaR1C1 = "=April!RC"
Range("B5").Select
Selection.AutoFill Destination:=Range("B5:B22"), Type:=xlFillDefault
Range("B5:B22").Select
Selection.Copy
Range("F5").Select
ActiveSheet.Paste
Range("J5").Select
ActiveSheet.Paste
Range("N5").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=18
Range("B29").Select
ActiveSheet.Paste
Range("J29").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=21
Application.CutCopyMode = False
End Sub
However rather than using the line below which looks at the sheet named April, I would like it to look at the sheet to the left of the active sheet.
ActiveCell.FormulaR1C1 = "=April!RC"
I'm sure this is really easy, but I just don't know anything yet.
Can anyone recommend a good beginners guide to help me learn about VBA?
Thanks