Explain Union and delRange to me.

[jhuang5132]

Is there any difference using

Please Login or Register  to view this content.

as opposed to

Please Login or Register  to view this content.

Also, I read that in Excel 2003, if the parameter/cell contains nothing within the Union, then that parameter is not selected. Is this still true in Excel 2010 onwards?

--------------------------

What exactly is

Please Login or Register  to view this content.

I couldn't really find any documentation on it explaining it in detail. All I could glean is that it is used to set a range to delete.

For example:

Please Login or Register  to view this content.

This code actually deletes it :

Please Login or Register  to view this content.

I'm assuming that if delRange has not nothing (aka has columns saved), then delete the range.

From what I understand, if the value is "Help" and delRange is not set, then set it to Column i. I don't really follow the part after the "Else". Does it mean that if there is already a delRange, then combine the previous delRange and the new Column i (which is repeated later on using next i code) together to be deleted later?

Also: bonus points if you can tell me what "Call" does. To me, it just seems similar to ".Select" but is it just used for functions?

[romperstomper]

Is there any difference using

Please Login or Register  to view this content.

as opposed to

Please Login or Register  to view this content.

No - unless you have another routine called Union.

Also, I read that in Excel 2003, if the parameter/cell contains nothing within the Union, then that parameter is not selected. Is this still true in Excel 2010 onwards?

No idea what you mean, I'm afraid.

What exactly is

Please Login or Register  to view this content.

I couldn't really find any documentation on it explaining it in detail. All I could glean is that it is used to set a range to delete.

It's just a variable name.

I don't really follow the part after the "Else". Does it mean that if there is already a delRange, then combine the previous delRange and the new Column i (which is repeated later on using next i code) together to be deleted later?

That's correct.

Also: bonus points if you can tell me what "Call" does. To me, it just seems similar to ".Select" but is it just used for functions?

It is used to call other routines. (it isn't required). It is nothing like .Select though.

[jhuang5132]

Thanks Rory, that was very informative. I didn't really realize that delRange was just a very common variable like LastRow. Would that also mean that

Set delRange = .Columns(i)

can just be stated as

delRange = .Columns(i)

or is "Set" necessary because it is in an If Function?


For the part you didn't understand, I was just bad at explaining.

----

Here's a direct quote:

The Union method, though, has two shortcomings. First, none of its input parameters may be Nothing. If any parameter is Nothing, the Union operation fails. A better union, described below, will ignore parameters that are Nothing and uses only the parameters that not Nothing to create the new range. The second shortcoming of Union is that it duplicates cells when the regions specified by the input parameters overlap. This can cause logic problems in your code since overlapping cells are included twice in the Union result.

http://www.cpearson.com/excel/BetterUnion.aspx

Would this still be applicable to 2010?

[romperstomper]

Set is necessary because delRange is an object variable, not a data type.

The Union method has not changed in 2010 - it still has the same limitations.

[jhuang5132]

Sorry, I don't quite follow that.

Is it an object variable because if refers to a range, rather than a value, which would be a data type?

[romperstomper]

That's correct.

[jhuang5132]

Thanks again! Useful information.

[romperstomper]

Glad to help. Please don't forget to mark the thread solved using the Thread Tools link at the top of the page.