Hi All,
This is probably a basic question... I have run into a couple of issues that lead me to believe that I may not completely understand Set object. I am hoping someone can clear things up.
I have always thought that the following code creates an object INSTANCE (e.g. a copy, but no ties to original object) of the object:
[EDIT: Incorrect assumption. Use the NEW keyword to create an instance of the object. SET by itself does in fact create a reference.]
I could then use the data in myRange as needed within the procedure. If, however, I wanted to affect the actual cells on the spreadsheet say to update a cell, I would have to point to the original object:Please Login or Register to view this content.
vsPlease Login or Register to view this content.
As I have worked through some coding issues today, I have discovered that when using some object methods/properties my assumption is correct. In other cases it is not.Please Login or Register to view this content.
Can someone explain this further?
Thanks,
John
Bookmarks