There are 2 objects which are on the same level in a line on this Macro. See below;
"Cells.Interior.ColorIndex = xlNone"
Here both "Cells" and "Interior" are Range Object Properties and they exist there succesively. It confused me.
There are 2 objects which are on the same level in a line on this Macro. See below;
"Cells.Interior.ColorIndex = xlNone"
Here both "Cells" and "Interior" are Range Object Properties and they exist there succesively. It confused me.
The Interior property of Cells returns an Interior Object.
ColorIndex is a property of Interior.
If posting code please use code tags, see here.
"ByVal Target As Excel.Range"
Where it should be A Data Type "Excel.Range" is written. I don't get that. (See the example file named "selection change event")
Why should it be a data type?
Also, what makes you think Excel.Range isn't a data type?
After "As" we define its data type. Don't we?
And is not Excel.Range a data type?
Thank you very much for help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks