| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing Column Ranges in UDF
I have a User Defined Function which takes a Range as an argument.
It processes the range as follows For RowNumber = 1 To DateRange.Rows.Count DateFrom = DateRange.Cells(RowNumber, 1).Value DateTo = DateRange.Cells(RowNumber, 2).Value ......(Further Processing) Next RowNumber This works fine for a range such as "C23:D50". How can I cater for the user entering a column range such as "C:D"? In this case I would want to loop down column C while it had valid data. Nirmal |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing users to edit selected ranges only | Excel Discussion (Misc queries) | |||
| Sum Multiple Ranges in the Same Column | Excel Discussion (Misc queries) | |||
| Data ranges within a column | Excel Worksheet Functions | |||
| How do I add different ranges in a column together? | New Users to Excel | |||
| Only Allowing Certain Codes In Column | Excel Discussion (Misc queries) | |||
![Nirmal Singh[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
