98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel.advanced.course - Change an Object's Property
excel.advanced.course - Change an Object's Property
Resolved · Low Priority · Version Standard
Fri 18 Jan 2008, 09:46Delegate Neil said...
Neil has attended:
Excel VBA Intro Intermediate course
Change an Object's Property
When can I just use code like:
Object = Value
and when do I need to use code like:
Set Object = Value
I'm not sure which applies in which case. Thanks!
Sat 9 Feb 2008, 11:16Trainer Stephen said...
RE: Change an Object's Property
Hi Neil
Thank you for your question
Simply put when you a assigning a value to an excel object then you must use the set command. So if you are naming a workbook, worksheet, range or other similar object use the set command.
however, if you are assigning a value to a simple variable then just use the variable = value syntax
Regards
Stephen
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Transpose textYou can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps: |
