VBA Error

[mgirvin]

Dear Excel Team,

I am new to VBA. I am reading the Mr Excel VBA book. I have defined a variable:

FinalRow = Cells(65530, 2).End(x1Up).Row

Every time I hit F8 and Execute, I get Error "Run time error 1004, Application-defined or object-defined error". I am pretty sure the problem is with the ".End(x1up)", however, this is how it is typed in the book.

The whole code is this:

'Test FinalRow
'by Gel 8/25/06
Sub TestFinalRow()
FinalRow = Cells(65530, 2).End(x1Up).Row

For i = 2 To FinalRow
If Cells(i, 2).Value > 0 Then
Cells(i, 2).Interior.ColorIndex = 6
End If
Next i

End Sub

Sincerely, Mike Gel Girvin

 

[HalfAce]

60 nested IFs . . .

Now that's just the kind of formula I'm not looking forward to having to try & dissect.

 

[Norie]

Mike

60 nested IFS?

Why?

 

[HalfAce]

60 nested IFS?

Why?

At this point I can only imagine it's "because he can!"

 

[mgirvin]

Dear Excel Team,

Yes, I tried it just to see if it could be done! I can't imagine needing 64!

Although... I have seen some ingenuous interest calculating formulas that used many IFs concatenated together (more than 7). In addition, before I knew how to use the OFFSET function, I had 30 IFs strung together to show the running Ledger balance at the bottom of the sheet.

Rest assured that there will be some that max out the 64 limit for both IF and Conditional Formatting soon after its release!