ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Excel2000 error 438 help (https://www.excelbanter.com/excel-programming/301234-vba-excel2000-error-438-help.html)

Stuart

VBA Excel2000 error 438 help
 
When I run my VBA macro it stops after running for a while with the error:

Run-time error '438':
Object doesn't support this property or method

Microsoft.com Knowledge Base 211731 says something about ActiveX (which I have not used and don't understand). My macro is basically two IF...THEN...ELSE loops, it is not written to do any formatting.

Can anyone help please.

Frank Kabel

VBA Excel2000 error 438 help
 
Hi
you may post your macro

--
Regards
Frank Kabel
Frankfurt, Germany


stuart wrote:
When I run my VBA macro it stops after running for a while with the
error:

Run-time error '438':
Object doesn't support this property or method

Microsoft.com Knowledge Base 211731 says something about ActiveX
(which I have not used and don't understand). My macro is basically
two IF...THEN...ELSE loops, it is not written to do any formatting.

Can anyone help please.




All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com