InputBox Cancellation

[nms2130]

I am having trouble with the Range type of Input Box being cancelled. I am using the code below and upon cancel I receive an object required message.
What am I doing wrong?

Please Login or Register  to view this content.

Thanks in advance

[Bob Phillips]

Please Login or Register  to view this content.

[Leith Ross]

Hello nms2130,

Here is another method you may be able to use. This method doesn't throw an error when the user cancels. This is because the macro uses a Variant. When the user cancels the input operation, it returns a Boolean value of False. When you select a Range, it returns a Variant Array.

This method is useful when only the Range values are needed. If you need to access formatting, formulas, or addresses then you need to use Bob's method.

Please Login or Register  to view this content.