Range format question

P

Pellechi

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

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

Thanks,

Jim Pellechi
 
B

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 L3:p4, 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)
 
Top