-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Book: VBA & Macros, page 108
- Thread starter Virgin
- Start date
Excel Facts
Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Derek Brown
Well-known Member
- Joined
- Dec 26, 2005
- Messages
- 2,390
Hello and welcome to The Board.
You did not give the version of Excel for the Book.
I have VBA and Macros for Excel 2013 and that does not have code on Page 108.
You did not give the version of Excel for the Book.
I have VBA and Macros for Excel 2013 and that does not have code on Page 108.
starl
Administrator
- Joined
- Aug 16, 2002
- Messages
- 6,081
- Office Version
- 365
- Platform
- Windows
It's not going to show up in your list of macros because it has an argument (ByRef CurrentTop as String)
Only subs with no arguments (Sub Name ()) show up in the list.
You need to create a Sub that calls NoNames, like this:
Sub TestNoNames
msgbox NoNames "John Doe"
end sub
The purpose of that code sample in the book, though, is for comparison purposes - it doesn't use Names to hold data. The next example in the book does use Names
Only subs with no arguments (Sub Name ()) show up in the list.
You need to create a Sub that calls NoNames, like this:
Sub TestNoNames
msgbox NoNames "John Doe"
end sub
The purpose of that code sample in the book, though, is for comparison purposes - it doesn't use Names to hold data. The next example in the book does use Names
