Run-time error '1004': Method 'Range' of object '_Global' failed

Hey,

I work for an accountancy firm which uses a bookkeeping package incorporated into Microsoft Excel via Visual Basic. We have been having a problem when we attempt to balance forward to the next accounting year. It is at this stage that we receive the Run-time error message 1004. It relates to the following piece of code;

Please Login or Register  to view this content.

The problematic piece of code highlighted by Visual Basic in debug mode is;

Please Login or Register  to view this content.

My knowledge of Visual Basic is school level standard and was wondering if anyone would know what the problem is.

Thanks in advance.

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

dv8, please take a few minutes to read the forum rules about posting in threads with pending moderation.

I suspect the ranges are not on the active sheet so you should qualify them with the sheet to which they belong:

Please Login or Register  to view this content.

If they are all on the same sheet, you can neaten that with a With...End With construction.

The ranges are all on the active sheet. I included the With .. End With construction just in case. Same Run Time Error 1004 being produced.

Then I would suspect that your code is not in a normal module, but in a worksheet module?
If you post a sample workbook, we could stop guessing...

If you click the Go Advanced button below the message box when posting, there is a Manage Attachments button that will allow you to upload a workbook. (Delete any confidential data first!)

Heres a blank version of the worksheet.

I had to zip the file as it would not seem to upload otherwise.

Thanks in advance.

Your obEnd range seems to have a #REF! error in it.