Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting & Displaying An Array's Contents
Given the following code which loops through an array
Sub ClearRange(ByVal s As String Dim v As Varian Dim i As Lon Dim ar As Rang v = Array("RangeName1", "RangeName2", "RangeName3 For i = LBound(v) To UBound(v For Each ar In ThisWorkbook.Names(v(i)).RefersToRange.Area If s = "Yes" The ' cycle through the entire range performing calculation Els ' Do nothing within the rang End I Next a Next End Su =============== What additional code must I insert (and where) to 1. Allow the user to select from a dialogue box which ranges to clear (with the default having all check boxes or radio buttons selected?, an 2. Display on the users screen which Range Name is currently running through the loop while the entire procedure is underway Thanks in advance Scot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying cell contents | Excel Discussion (Misc queries) | |||
Selecting data from columns and displaying them as rows | Excel Discussion (Misc queries) | |||
Selecting vertical rows and displaying them horizontally. | Excel Discussion (Misc queries) | |||
Displaying Cell Contents | Excel Discussion (Misc queries) | |||
Need help displaying array contents | Excel Programming |