Hi Jerry,
In Excel 2002, the Edit->Fill->Down shortcut key is
CTRL+D. Is there a way to refine the shortcut?
When I press CTRL+D, Excel gives me a "Run-time
error '1004': Method 'Range' of object '_Global' failed"
error.
Obviously some add-in or another macro has hijacked the shortcut key.
See if any of these may help you find the cause:
Try opening Excel without any addins or hidden workbooks:
Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation
Quotes mandatory, Note you may have to change the path.
If your error disappears, there is either an add-in or a (hidden)
workbook that is loaded upon XL's start, which bothers you.
- Try locating the XLSTART directory, move everything from there.
- In XL: Tools, Addins, note the ones checked and uncheck them one at
the time, each time restarting XL
- In XL, Tools, options, general. Check if a path is entered after
"Alternate startup file location". Clear it.
Now restore the things above one-by-one to find the offending item.
Regards,
Jan Karel Pieterse
Excel MVP
www.jkp-ads.com