Thread: Cells(1)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] d.e.lindstrom@gmail.com is offline
external usenet poster
 
Posts: 18
Default Cells(1)

On Wednesday, December 12, 2018 at 5:24:26 PM UTC+11, GS wrote:
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


Thank you!!