excel.advanced.course - Change an Object's Property

Resolved · Low Priority · Version Standard

Fri 18 Jan 2008, 09:46 Delegate 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:16 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips