Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have few .xls with macros written and tested on XP based Excel. However,
the same .xls when used on NT based Excel generate a Dr. Watson. All the macro statements are perfectly compatible with NT version, no fancy features used. Any idea on what could be the potential cause of the error? To help you zoom in the problem I have reproduced one of the many macros that generate a Dr. Watson on NT machines. Thanks a lot for your help. Sub Select_View() ' ' Select_View Macro ' Based on user selection, a filter in column of business view is activated. ' This column is a hidden column, thus first step is to unhide the column. ' Next step is to apply approrpriate filter criteria ' Last step is to re-hide the column ' ' r = MsgBox("Do you want only Business View? (Yes = Only Business view, No = Entire view)", vbYesNo, "Select View") Selection.AutoFilter Field:=4, Criteria1:="<" Range("A1").Select ActiveSheet.ShowAllData ActiveCell.Select If r = vbYes Then ActiveCell.Offset(0, 16).Columns("A:C").EntireColumn.Select Selection.EntireColumn.Hidden = False Selection.AutoFilter Field:=17, Criteria1:="Yes" Range("A1").Select ActiveCell.Offset(0, 16).Columns("A").EntireColumn.Select Selection.EntireColumn.Hidden = True Range("A1").Select Else If r = vbNo Then Range("A1").Select Else r = MsgBox("error in reply", vbOKCancel, "msg") End If End If ActiveWindow.Visible = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007/macros not working | Excel Worksheet Functions | |||
Macros not working when file run on a Mac | Excel Discussion (Misc queries) | |||
Working with Macros - Help needed!!! | Excel Discussion (Misc queries) | |||
HELP : Excel 4 macros not working any more | Excel Programming | |||
Advise, please, how to get the following macros working: | Excel Programming |