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 |
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) |