What is "set" for??

[daviddoria]

Isn't '=' usually the assignment operator? Why do you have to use 'set =' for some things?

Please Login or Register  to view this content.

Thanks
Dave

[royUK]

You use set when the variable refers to a range, sheet or workbook i.e. if it refers to an object

[chadmount]

How can I use the Application.InputBox method to select worksheets with the mouse? I'm using it to select columns with the mouse but I can't figure out how to select sheets. Any ideas?

Here's how I select the columns:

Please Login or Register  to view this content.

[Leith Ross]

Hello chadmount,

Please start a new thread...

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Sincerely,
Leith Ross