Macro used to work and now does not

It looks like rangetocheck is supposed to be the title (albeit a strange one) of the inputbox. Is it supposed to be a variable that stores the string for the input box? Or is the title supposed to be "rangetocheck"?

It seems you have Option Explicit at the top of the module now but didn't before. Add:

Please Login or Register  to view this content.

Originally Posted by Trevasaurus

Thanks Solus.

I think it was supposed to be the input box variable. So, I defined that as a string but now I'm getting the same error message but for 'Cell.' I've never had to define Cell as a variable in VBA. Any suggestions for that?

Believe it or not Cell is not an object in VBA. Cells is a collection, but to refer to one "Cell" as you are attempting to do you have to define the variable (the word Cell is now a variable) as a Range. The experts have pointed out it is probably because now the VBE has option explicit turned on which requires you to declare all variables, and their solutions should get you fixed up.


e/ On a side note, even with option explicit turned off it is good idea to fully qualify all variables by defining them and assigning a proper data type.

Xero,
Believe it or not Cells is not an object, nor a collection in VBA.
Cell is simply a range object that consists of just one element.

As Xero said, Cells is a Collection. Cell is just a variable - it has no intrinsic meaning other than as defined in any given piece of code.

Rory,
This statement is from J Walk's book
"Notice That I wrote cells property, not cells object or even cells collection. Although cells may seem like an object(or a collection), it is not really".

I know what you mean (although you said Cell, not Cells ) but in terms of its behaviour Cells is effectively a Collection, at least as far as the compiler is concerned - in much the same way that Rows and Columns are, even though they theoretically all simply return Range objects.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

e/ Wrong application.

That's Word, though.

Sorry I was on my phone. I suppose cells is a property.


e/ That's why you guys are the experts