Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range format question
Could someone explain what the (1) means in the following format:
Set Target = Range("Tbl_una_days")(1) Thanks, Jim Pellechi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
Range to echo format (hilite/fontcolors) of sister range? | Excel Worksheet Functions | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
Range.Formula and Range question using Excel Automation | Excel Programming |