Logo 
Search:

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: 898
  

Sub Macro1()
'
' Macro1 Macro

'
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: 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.




Tagged: