Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to sort tables of data results. Results for differant areas are stored
on differant worksheets in one workbook. Some of the worksheets do not contain result data. The required range is defined as several contiguous columns. How can I define the range once, and yet apply it to the result sheets from VBA. Do I have to write a function to convert the named range column referances to a string format suitable for defining a range? Or is there an existing function/method I am missing. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Define Name range | Excel Discussion (Misc queries) | |||
Define a range | Excel Discussion (Misc queries) | |||
sheet protection - only selected range to be able to select/input data | Excel Worksheet Functions | |||
how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions |