Any Excel Visual Basic Guru's out there ?

[Mat7777]

'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

 

[MPwannadecentincome]

Why would anyone here debug the code for free for you?

Have you tried googling "'Run time error 1004".

Have you narrowed it down to which bit of code gives the error?

Once you have the snippet of code you might be able to post on various technical forums for Excel VBA for help.

 

[lilelvis2000]

Uhhh...you know there is a debugger in excel? Try using it.
Then ask the question about a specific line/block of code.

 

[xoggoth]

VBA is generally as easy as programming gets but not to say all probs are dead simple. Message me and as a retired old git I'll have a QUICK look if you like. Not spending ages on it tho.

 

[xoggoth]

A likely problem if it used to work is that the code is referring to a named range on the sheet, eg Sheet1.range("list").Value, and it has been deleted. Easy to do. Or similarly if it refers to a named sheet and someone has renamed the sheet.

 

[BoredBloke]

Debug it and cut and paste the line into this. As was said its probably because somebody has renamed/deleted something

 

[MikeC1408]

It is indeed an issue with a named range.