lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I found that the data type of Selection is "Object". I am trying to understand the code below. So the data type of Selection is Object. That does not help! how can I know what is the properties and functions of that object?
How can someone know SpecialCells is a function or property of that object.
I tried to use Object Browser to find out what is inside OBJECT but nothing came up.
I found that the data type of Selection is "Object". I am trying to understand the code below. So the data type of Selection is Object. That does not help! how can I know what is the properties and functions of that object?
How can someone know SpecialCells is a function or property of that object.
I tried to use Object Browser to find out what is inside OBJECT but nothing came up.
Code:
Sub del_blank()
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.Delete
End Sub