I'm a professional programmer but new to programming Excel. I recently found
an example on the internet that has the line 'Set rng = Range("Database")' in
it. Everything works fine in the example. When I modify the code and try to
use it on my spreadsheet I get an error on the 'Set rng = Range("Database")'
line. The error is: Run-time error '1004': Method 'Range' of object
'_Global' failed. Any ideas as to why it works on the example but errors on
my spreadsheet?

Thanks,
Tom