Use of integer variable for sizing of matrix

[Cor Steeghs]

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

 

[Cecilkumara Fernando]

Steeghs,
n = Worksheets("LOAD_A").Range("a" & Rows.Count).End(xlUp).Row
Worksheets("LOAD_A").Range("A2:A" & n).Name = "WGHTLDA"
Cecil

 

[keepitcool]

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 >