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 ?
 

Post it or send to my address below

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

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