| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of integer variable for sizing of matrix
Hello,
I would like VBE to check rowcount in column a, then make a named range, more like : n = Worksheets("LOAD_A").Range("a" & Rows.Count).End(xlUp).Row Worksheets("LOAD_A").[A2:A10].Name = "WGHTLDA" only, instead of ending the named range at A10, I want it to end at the n-th row... Thanks for your attention and/or reply and best regards, Cor Steeghs |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use of integer variable for sizing of matrix
Steeghs,
n = Worksheets("LOAD_A").Range("a" & Rows.Count).End(xlUp).Row Worksheets("LOAD_A").Range("A2:A" & n).Name = "WGHTLDA" Cecil "Cor Steeghs" wrote in message ... Hello, I would like VBE to check rowcount in column a, then make a named range, more like : n = Worksheets("LOAD_A").Range("a" & Rows.Count).End(xlUp).Row Worksheets("LOAD_A").[A2:A10].Name = "WGHTLDA" only, instead of ending the named range at A10, I want it to end at the n-th row... Thanks for your attention and/or reply and best regards, Cor Steeghs |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use of integer variable for sizing of matrix
If you create a NamedRange in LOAD_A
like dnDATA=offset(a1;0;0;counta(a:a);counta(1:1)) then you can just load that instead. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Cor Steeghs wrote: Hello, I would like VBE to check rowcount in column a, then make a named range, more like : n = Worksheets("LOAD_A").Range("a" & Rows.Count).End(xlUp).Row Worksheets("LOAD_A").[A2:A10].Name = "WGHTLDA" only, instead of ending the named range at A10, I want it to end at the n-th row... Thanks for your attention and/or reply and best regards, Cor Steeghs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
| Random Integer | New Users to Excel | |||
| How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
| integer | Excel Worksheet Functions | |||
| positive integer? | Excel Discussion (Misc queries) | |||
Linear Mode
