Range format question

  • Thread starter Thread starter Pellechi
  • Start date Start date
P

Pellechi

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

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

Thanks,

Jim Pellechi
 
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)
 
Back
Top