Range format question

[Pellechi]

Could someone explain what the (1) means in the following format:

Set Target = Range("Tbl_una_days")(1)

Thanks,

Jim Pellechi

 

[Bob Phillips]

Pellechi,

It qualifies the range to the first cell in that range, the top-left cell.
So if the range is a range of say 10 cells (2x5) covering L34, Target will
be a range object simply covering L3.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)