Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range efficiency
hello,
I have a range of reports that run in Excel using stored procs from SQL where variables are ascertained using cells from a spreadsheet. I need these variables to be more user efficient so am trying to write a module that will raise each of them as variables choosing all populated cells for each column. The easiest way to put all that babble into an example, would be that my report has a combo box for week number, and all the necessary week numbers are held in my "variables" spreadsheet, how can I select a range on all those week numbers when I don't know how many are in the column? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
can a formula check for a certain value in a range? | Excel Discussion (Misc queries) |