![]() |
Simple Answer ?
'Hi folks Ive just been handed an Excel spreadsheet with some VB code that apparently "used to work ok" and am expected to fix it ! I know very very little about VB and wondered if anyone could fix the code for me ? The error I get in Excel when hitting the "Button" is 'Run time error 1004' 'Application-defined or object-defined error' If there isnt a simple solution - does anyone feel like having a look at the code for me ? Any help greatly appreciated Cheers Mat |
Simple Answer ?
copy the code for us to see. that error usually occurs when an object
doesn't exist --- typically trying to select a range name where there isn't one "Mat" wrote in message ... 'Hi folks Ive just been handed an Excel spreadsheet with some VB code that apparently "used to work ok" and am expected to fix it ! I know very very little about VB and wondered if anyone could fix the code for me ? The error I get in Excel when hitting the "Button" is 'Run time error 1004' 'Application-defined or object-defined error' If there isnt a simple solution - does anyone feel like having a look at the code for me ? Any help greatly appreciated Cheers Mat |
All times are GMT +1. The time now is 11:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com