View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William Wolfe William Wolfe is offline
external usenet poster
 
Posts: 18
Default It Then Else Question

What is wrong with the following code? I get a compile error 'Else without
IF"

If LinkBudget.Range("E143") < -14 Then
Detail_Report.Cells(61, Column).Select
With Selection.Interior
.Color = 6750105
Else
Detail_Report.Cells(61, Column).Select
With Selection.Interior
.Color = 255
End If

Thanks,

W Wolfe