Tips, Tricks and Traps (More) Excel.Application & Excel.Range

Questions

1.       How to stop the screen from flickering during a long-running program?

2.       What statement requires that the programmer explicitly type each variable?

3.       What method of the range object can be used to extend the number of columns in a range from 3 to 6?

4.       What property of the range object would put 5 in cell $A$1?

5.       What function displays both a message and icons like the one in Figure 1 to the user?

   Figure 1

  

6.       What function determines whether a cell is populated with data?

7.       How to set the default indexing of an array to start at 1?

8.       What method of the Application prevents recursively calling an event’s code written for a Sheets, Workbook or Application object's event?

9.       What property of the Application object suppresses the warning message that Excel display’s when certain action- like OverWriting a file are performed

10.   What is the method of the range object that will select all the cells from A1 to C3?

11.   Bonus: If data has been copied to the clipboard, what method of the range object would copy it’s contents to a new range?
 

 

Answer Key

1.       Application.ScreenUpdating =False

2.       Option Explicit

3.       Resize method

4.       Value property

5.       MessageBox function

6.       IsEmpty()

7.       Option Base 1

8.       Application.EnableEvents=False

9.       Application.DisplayAlerts property=False

10.       Range(“A1:C3”).Select

11.       Range.PasteSpecial