Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
JUST PERFECT!
Many many thanks!!!! Hope I am able to help you some day! Regards, Raphael -----Original Message----- Somewhere before you get the error, put this line in: On Error Goto ErrHnd Then at the end of your subroutine (before End Sub) put this: Exit Sub ErrHnd: Err.Clear End Sub This will essentially ignore your error and not show a message. Note that it ignores all errors, so if things stop working right, you will need to comment out the On Error Goto ErrHnd statement. K --- Message posted from http://www.ExcelForum.com/ . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error 400 when running Macro | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Error Running a Macro | Excel Discussion (Misc queries) | |||
KERNEL32.DLL error after running EXCEL Macro | Excel Programming |