Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying cell contents BlueAngel Excel Discussion (Misc queries) 3 March 6th 10 01:12 AM
Selecting data from columns and displaying them as rows chrisvail Excel Discussion (Misc queries) 2 October 7th 09 06:28 PM
Selecting vertical rows and displaying them horizontally. chrisvail Excel Discussion (Misc queries) 2 October 6th 09 11:48 PM
Displaying Cell Contents ajones1978 Excel Discussion (Misc queries) 3 September 10th 08 10:35 PM
Need help displaying array contents jsatz Excel Programming 3 October 3rd 03 09:33 PM


All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"