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

**mdvc** · 10-20-2011, 09:10 AM

Hi,
I am very new to VBA and am looking at a former colleague's worksheet. There is a macro in this worksheet which automatically creates 3 additional blank rows near the bottom of a spreadsheet.

Unfortunately this macro does not seem to be working any more. I have copied the code for the macro below.

Please Login or Register  to view this content.

The row that the debugger selects as causing the error is:

Please Login or Register  to view this content.

Any help will be very gratefully received.

Thanks

**romperstomper** · 10-20-2011, 09:54 AM

Are you sure that Range exists?

Note: when adding code tags, you need to select the code, then click the code tags button, or enter them manually using:
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]
I have corrected them for you on this occasion.

**mdvc** · 10-20-2011, 11:01 AM

RS,
Thanks for correcting my post.

I have referred to the 'name manager' function in Excel and it does show that range, but its value is #NA, and its refers to value is #NA. From memory, this workbook started malfunctioning when our computers were switched from Excel 2003 to Excel 2007. Do you know how I can solve this problem.

Many thanks.
MDVC