error 1004 application defined error (Moving click button)

**mdavid800** · 08-08-2011, 09:40 AM

Hi there

I was wondering if any you could help.

I have this code that has been working fine. To run the code I was using a click button which up until now has been located on the same sheet (called “Hourly_ Calculations”). Now I would like to move the button to another sheet (Called “Data_Input”) so it is easier for the user. This seems to be causing problems. I know I need to be telling VBA what sheet to use otherwise it will assume the activesheet I think this is were the problem lies but I think I am doing this already, however I am probably incorrect

Anyhow the debugger highlights this line of code

Please Login or Register  to view this content.

This line of code is included in an if statement as below

Please Login or Register  to view this content.

I’m new to this but I don’t understand why its not working as the sheet the range is on is referred to in the code,

Where am I going wrong

Thank you

**Andrew-R** · 08-08-2011, 09:45 AM

Assuming that you do have variables called off2 and off3 then I'd guess that the cells function isn't referring to the sheet you think it is.

If you replace the line giving an error with:

Please Login or Register  to view this content.

Does that sort out the issue?

**Mordred** · 08-08-2011, 09:49 AM

Hi mdavid800, perhaps it would be best if you posted your full procedure for us to look at and try to find a solution.

**Mordred** · 08-08-2011, 09:49 AM

Or Andrew-R has solved it for you

!

**mdavid800** · 08-08-2011, 09:56 AM

that did not seem to change anything Andrew. as suggested here is the full procedure encase it helps.

Please Login or Register  to view this content.

**Andrew-R** · 08-08-2011, 10:03 AM

Is it still breaking on the same line if you make my change? Did you cut and paste from my example or retype it? If the latter did you make sure you used .Cells rather than Cells?

**Mordred** · 08-08-2011, 10:05 AM

Hi mdavid800, this is not tested but copy and past the following procedure back into you module.

Please Login or Register  to view this content.

**mdavid800** · 08-08-2011, 10:13 AM

Hi there guys. Sorry Andrew you were correct i typed it in and missed the .cells when i copied/pasted it seemed to do the trick.

Thanks both of you for the help.

David