| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells(1)
What feature of Excel VBA am I using when I address cell "A1" as Cells(1)?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| Select Merged Cells and Unmerge Spread Merge Data To All Cells | Excel Programming | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells | Excel Programming | |||
Linear Mode
