Thread: Cells(1)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Cells(1)

What feature of Excel VBA am I using when I address cell "A1" as Cells(1)?

Its INDEX!
Cells(1) assumes the 1st cell in column 1 when no argument is specified.
Cells(1) = Cells(1,1)

In a range...
Range("A1:D8").Cells(1) refs A1
Range("A1:D8").Cells(32) refs D8
Range("A1:D8").Cells(16) refs D4
Range("A1:D8").Cells(8) refs D2

...where count is left-to-right, top-to-bottom

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion