Excel experts - Best way to learn macros and VBA in Excel?
Thread Starter
Burning Brakes
Joined: Mar 2001
Posts: 1,131
Likes: 0
From: Austin, TX
Excel experts - Best way to learn macros and VBA in Excel?
For you excel masters... I'm trying to learn how to make buttons that take you to different worksheets, print certain ranges automatically, etc...
How is the best way for me to learn how to do this kind of stuff?
How is the best way for me to learn how to do this kind of stuff?
Suzuka Master
Joined: Sep 2000
Posts: 9,431
Likes: 0
From: Woodstock, GA
Record a Macro, view the code and alter it as needed.
You'll end up with code like this:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/11/2003 by Steve Calbert
'
'
Range("A1:A3").Select
Selection.PrintOut Copies:=1, Collate:=True
End Sub
You'll end up with code like this:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/11/2003 by Steve Calbert
'
'
Range("A1:A3").Select
Selection.PrintOut Copies:=1, Collate:=True
End Sub
Thread
Thread Starter
Forum
Replies
Last Post
4drviper
3G TL Audio, Bluetooth, Electronics & Navigation
1
Apr 23, 2025 07:13 PM
Bobinator
1G RDX Photograph Gallery
17
Jan 4, 2021 01:30 PM
InFaMouSLink
Car Parts for Sale
6
Oct 27, 2015 06:52 PM
