Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Macro in Excel

  Asked By: Madeleine    Date: Feb 25    Category: MS Office    Views: 764
  

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 1/20/2007 by Eric Eastman
'
For i = 1 To Sheets.Count
Sheets(i).Visible = True
Sheets(i).Select
Selection.EntireColumn.Hidden = False *
Selection.EntireRow.Hidden = False
If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If
Cells.Select
Selection.Columns.AutoFit
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?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Bethany Hughes     Answered On: Feb 25

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.




Tagged: