Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
define range using col and row names; not cell name
How do you set a range using these four names? They define whole rows
and columns. The first column and row, along with the last column and row, define a range first_data_col last_data_col first_data_row last_data_row I can select columns with, as an example: mySheet.Range(mySheet.Range("first_data_col"), mySheet.Range("last_data_col")).EntireColumn.Hidde n = False I'm trying to do a sort, but I have to define the range to sort, as in ws.Range("D7:L25"), but I don't have cell names, I have 4 whole row and column names ( such as $K:$K, and $4:$4) I could disassemble these names and build a range with Cell, but isn't there a better way? I know this has got to be simple, but I just can’t seem to make it work. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define Range Names in Excel 2003-SP2 | Excel Discussion (Misc queries) | |||
Define range by last cell in column? | Excel Programming | |||
Macro to define range names | Excel Programming | |||
define Range in vba using contents of a cell that is named | Excel Programming | |||
how to define range names | New Users to Excel |