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