Referring to set variable range.cells

[boela]

Hi All,

I am having difficulty understanding why the following code won't work. I get a "Compile error: Method or data member not found" on .InputRng.

Here is the code:

Please Login or Register  to view this content.

For some reason that I can't understand the following code does work (where I do not set a variable to the range object):

Please Login or Register  to view this content.

The sub also runs with the following code:

Please Login or Register  to view this content.

I just can't figure out why the syntax for the fist sub gives the error.
I am still learning the ins and outs of VBA so please assist. Many thanks.

[millz]

The problem is because using this

Please Login or Register  to view this content.

Sets InputRng to the active sheet.

If your active sheet is not Worksheets("Input"),

Please Login or Register  to view this content.

will give you the error.