John Kauffman
New Member
- Joined
- Oct 13, 2011
- Messages
- 23
All of following using VBA.
I have an exercise for students to help them understand Range().Properties
They use VBA to read various properties of a range and put those property values in B1:B10. For example,
Range("B1").value = Range("RangeDemo").HasFormula.
B1 then shows true/false as they experiment with changing RangeDemo
In A1:A10 I would like them to put the name of the property (using VBA). For example A1 should display "HasFormula" which would indicate the contents of B1.
How can I set a cell.value to the name of a property (not the value of the property)?
I have an exercise for students to help them understand Range().Properties
They use VBA to read various properties of a range and put those property values in B1:B10. For example,
Range("B1").value = Range("RangeDemo").HasFormula.
B1 then shows true/false as they experiment with changing RangeDemo
In A1:A10 I would like them to put the name of the property (using VBA). For example A1 should display "HasFormula" which would indicate the contents of B1.
How can I set a cell.value to the name of a property (not the value of the property)?