Differences between VBA in 2003 vs 2007

[Melpp]

I had a working code in Excel 2003 but it does not seem to run in Excel 2007. The first error that comes up is related to the following line:
Last_Row = ActiveSheet.UsedRange.Rows.Count

Please Help

 

[VoG]

That should work (but may be inaccurate). What is the error message?

 

[Melpp]

I get the following:

Compile error:

Can't find project or library

 

[VoG]

Check for missing references http://www.cpearson.com/excel/MissingReferences.aspx

 

[Melpp]

None of the references are missing.

It seems that if I define the varaibles at the begining of the code (such as: ' Dim Max').

But I am now getting an error on the following line:
If Cells(j, 13 + 3 * z) <> blank Then

Recall that this code runs perfectly in the 2003 version so why am I having so many problems in the 2007 version.

 

[shg]

Blank is a declared variable?

It sounds like you now have Option Explicit at the top of the module, requiring you to define variables, and previously did not.

 

[Melpp]

How do I change this option?

Under VBA--> Tools--> Options, the 'require Variable Declaration' is NOT checkmarked so why am I still having this problem?

 

[shg]

It should be checked, and you should declare your variables. But you didn't answer my question ...

 

[Melpp]

Blank is not a delcared variable....or atleast I never had to declare it in Excel 2003. I used blank to indicate that there is no content in a cell

 

[shg]

When you don't require variable declaration and just stick in a new variable name, a Variant variable is created, and its initial value is Empty, which is the same as an empty cell. So your code works serendipitously, not by design.

If you want to test if a cell is Empty, use IsEmpty(cell.value).