Page 89 - Excel Progamming Weekend Crash Course
P. 89
e540629 PR01.qxd 9/2/03 9:28 AM Page 64
64 Part I — Friday Evening
20. Suppose more than one workbook is open in Excel. How would you activate a spe-
cific workbook?
21. How can you tell if a workbook has been saved since the last time it was changed?
22. What restrictions, if any, are there on using the line continuation character in VBA
code?
23. What are VBA’s rules for indenting code?
24. How does VBA store dates internally?
25. You declare a VBA array as follows: Dim Data(100) As Integer. How many ele-
ments does the array contain?
26. How can a program determine the size of an array?
27. What does variable scope refer to?
28. How would you declare a variable to be available throughout the entire project?
