Hide columns Macro not working

[jbridge]

I am encountering the following error in VBA while using Excel 2007/Windows XP:

Run-time error '1004':
Unable to set the hidden property of the range class

Below is the coding which works in months October through January. February(nor will March through September) will not work even though coded the same as other months.

Any ideas to correct very much appreciated??


Private Sub CommandButton3_Click()
'This section unhides every column to start with.
Range("C:es").Select
Selection.EntireColumn.Hidden = False
'The next sections will show months that have actual numbers or the forecast if there are no actuals
'October
If Cells(10, 14).Value = 0 Then
Range("c:l,n:n").Select
Selection.EntireColumn.Hidden = True
Else
Range("c:l").Select
Selection.EntireColumn.Hidden = True
End If
'November
If Cells(10, 14 + 12).Value = 0 Then
Range("o:x,z:z").Select
Selection.EntireColumn.Hidden = True
Else
Range("o:x").Select
Selection.EntireColumn.Hidden = True
End If
'December
If Cells(10, 14 + 24).Value = 0 Then
Range("aa:aj,al:al").Select
Selection.EntireColumn.Hidden = True
Else
Range("aa:aj").Select
Selection.EntireColumn.Hidden = True
End If
'January
If Cells(10, 14 + 36).Value = 0 Then
Range("am:av,ax:ax").Select
Selection.EntireColumn.Hidden = True
Else
Range("am:av").Select
Selection.EntireColumn.Hidden = True
End If
'February
If Cells(10, 14 + 48).Value = 0 Then
Range("ay:bh,bj:bj").Select
Selection.EntireColumn.Hidden = True
Else
Range("ay:bh").Select
Selection.EntireColumn.Hidden = True
End If

 

[JoeMo]

At what line are you receiving the error message? Click on Debug when you get this message and see which line is highlighted.

 

[jbridge]

The line below is the error(same error for all subsequent months past Feb)

Selection.EntireColumn.Hidden = True

 

[JoeMo]

The line below is the error(same error for all subsequent months past Feb)

Selection.EntireColumn.Hidden = True

There's nothing wrong with this line. Try stepping through the code. When you get to the line before this one, verify that the columns you want to hide are selected. If so, then delete the offending line and re-type it from scratch to see if that corrects the problem.

 

[jbridge]

Thanks. That worked for the first month of Feb. I re-typed the code on line before "highlighted" one.

Now it errors out on the next month so trying to re-type not working... very buggy.

 

[JoeMo]

Thanks. That worked for the first month of Feb. I re-typed the code on line before "highlighted" one.

Now it errors out on the next month so trying to re-type not working... very buggy.

Your code is OK so stay with the re-typing. Sometimes Excel doesn't see what you've typed the way it appears to you.