Type Range incompatible for Address

[Warluck]

Bonjour,
I am trying to capture into a variable then address of an adjacent cell currently being modified.

The macro actually works when cell are being modified but capturing the address into a range variable leads to an incompatible type error.

Please Login or Register  to view this content.

When using only the MsgBox, the correct cell is displayed but when the Set rng = is active (not commented) I get the incompatible type error message.

Thanks

[Norie]

The Address property is a String, not a range and you only use Set with objects.

Try declaring rng as String and changing Set rng =... to rng = ...

[Kenneth Hobson]

Set means you are setting an Object. A string (the .Address part) is not an object. Use:

Please Login or Register  to view this content.

You used Call properly but I usually do this:

Please Login or Register  to view this content.

If your ManageCopyButton needs a range object, then that will work. If it needs a string then rng.Address(External:=True) probably needs to be sent.

[Warluck]

Thanks Norie, it works now but leaves me confused as to why it is a String and not a Range!

[Warluck]

Set means you are setting an Object. A string (the .Address part) is not an object. Use:

Please Login or Register  to view this content.

You used Call properly but I usually do this:

Please Login or Register  to view this content.

If your ManageCopyButton needs a range object, then that will work. If it needs a string then rng.Address(External:=True) probably needs to be sent.

Thanks Kenneth, that gives me some explanation. Will do some reading to make sure I understand correctly the concept.