MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Macro in Excel

  Asked By: Kimberly    Date: Mar 19    Category: MS Office    Views: 1077

Sub Macro1()
' Macro1 Macro

For i = 1 To Sheets.Count
Sheets(i).Visible = True
Selection.EntireColumn.Hidden = False *
Selection.EntireRow.Hidden = False
If ActiveSheet.FilterMode Then
End If
Next i
End Sub

When I run this macro against a sheet that has a comment in one of the
cells, in a column that's not hidden, I get "Runtime Error 438: Object
doesn't support this property or method" on the statement with the *.
I don't get the error with columns that don't have comments, even if
they aren't hidden.

Does anyone have any ideas?



1 Answer Found

Answer #1    Answered By: Candace Foster     Answered On: Mar 19

Works OK in XL2003; two questions:
What version of Excel are you using?
Does the comment  contain anything more than just text?

Didn't find what you were looking for? Find more on Macro in Excel Or get search suggestion and latest updates.