lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
From Object Oriented point of view, I understand Cells is a property of Range Class and its type is Range. So I understand this code
but what I do not understand this
Where it says Cells takes Row, and Column as arguments? If you check Range class, you would see Cells defined as
Property Cells As Range
Nothing mentioned about Row and Column?
https://docs.microsoft.com/en-us/office/vba/api/excel.range.cells
Any help would be very much appreciated. Thank you
From Object Oriented point of view, I understand Cells is a property of Range Class and its type is Range. So I understand this code
Code:
cells.clear
but what I do not understand this
Code:
cells(1,1).value ="hello"
Where it says Cells takes Row, and Column as arguments? If you check Range class, you would see Cells defined as
Property Cells As Range
Nothing mentioned about Row and Column?
https://docs.microsoft.com/en-us/office/vba/api/excel.range.cells
Any help would be very much appreciated. Thank you