IsEmpty Compile Error

[Russj62]

I am trying to recreate the IsEmpty macro on page 69 of "VBA and Macros for Microsoft Office Excel 2007" but I am getting a compile error on IsEmpty. I am sure that I have a very obvious (to others) problem but can not identify what is wrong.

 

[Richard Schollar]

Hi Russ

Can you post the code you are getting the compile error on please - thanks!

 

[Russj62]

Here it is:


Sub IsEmpty()
LastRow = Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To LastRow
If IsEmpty(Cells(i, 1)) Then
Cells(i, 1).Resize(1, 4).Inteior.ColorIndex = 1
End If
Next i

 

[starl]

You can't call the sub "IsEmpty" - because that's the name of a function in Excel.
Because you did call it IsEmpty - Excel expects your call within the code to be referncing the sub itself, which has no arguments.

Call the Sub ColorBlankRows - as it is in the sample files that you can download
You also spelled Interior wrong.

 

[Russj62]

I knew it was something simple like that. Thank you very much.