Range format question
 

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

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

Thanks,

Jim Pellechi

Range format question
 

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)

"Pellechi" wrote in message
. net...
Could someone explain what the (1) means in the following format:

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

Thanks,

Jim Pellechi