Set rng = ActiveSheet.UsedRange

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hugo & Monique" wrote in message
...
Hi,

I am trying to resize a named range (extracted from a database) according
to
the actual number of rows which varies each time I dump records from that
database.
Since I don't want to do this manually each time, I would like to automate
this task. Can someone give me a hint on how this can be done in VBA ?

Thank you !

Monique
Belgium