Home > Forum Home > Excel Portfolio Optimization Template > Run time error 438 | Share |
Forum Topic | Post Reply Login |
Run Time Error 438 | Rate this: (3/5 from 1 vote) |
![]() | is anyone can help me with this,when i run this program, this window appreas microsoft visual basic running time error '438' then, i can only stop this program THANK YOU~ | |
meilin | ||
Posted by meilynn on |
Replies - Displaying 1 to 10 of 13 | Order Replies By: Most Recent | Chronological | Highest Rated |
![]() | Rate this: (4/5 from 2 votes) |
Posted by lalbuerme on |
![]() | Rate this: (4/5 from 2 votes) Resolution Process
Rachel Gomez |
rachel | |
Posted by RachelGomez161999 on |
![]() | Rate this: (3/5 from 1 vote) Select Addins from the Tools menu Click the Browse button Navigate to C:\Program Files (x86)\Jetreports Select the Jetreports.xla file Click OK if you receive a prompt to overwrite, click Yes The Jet Excel add-in should now be re-added. Regards, Peter |
Posted by petergroft on |
![]() | Rate this: (3/5 from 1 vote) Select Addins from the Tools menu Click the Browse button Navigate to C:\Program Files (x86)\Jetreports Select the Jetreports.xla file Click OK if you receive a prompt to overwrite, click Yes The Jet Excel add-in should now be re-added. Regards, Peter |
Posted by petergroft on |
![]() | Rate this: (3/5 from 1 vote) Here's the specific line which Excel 2003 pointed out when I clicked "debug" as you suggested to do -- ActiveWorkbook.Worksheets("Value of Incentives by Cust").Sort.SortFields.Clear Any idea what the issue might be? As I mentioned before the macro runs perfectly in Excel 2007. Thanks much! |
[email protected] | |
Posted by bobcresto on |
![]() | Rate this: (3/5 from 1 vote) See my macros below: Macro 1) VBA Code:
Macro 2) VBA Code:
| ||
[email protected] | |||
Posted by bobcresto on |
![]() | Rate this: (3/5 from 1 vote) I get a run time error 438 prompt. What do I need to do to avoid this error prompt when trying to specify which worksheet a row and column are located in? |
Posted by Hwbell on |
![]() | Rate this: (3/5 from 1 vote) If you like, you can send through the template as a reply to the notification of this post and we can investigate this for you. |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
![]() | Rate this: (3/5 from 1 vote) |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
![]() | Rate this: (3/5 from 1 vote) Thank you in advance. |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Displaying page 1 of 2 | Next |
Find relevant Excel templates and add-ins for Run time error 438 in the Excel Business Solutions Directory |