If this doesn't help, you may want to post the text of the error message.

Here's an article that explains how the problem occurs in VBA (with solution)
http://support.microsoft.com/default...;en-us;q110462
XL: ShowDataForm Method Fails If Data Can't Be Found



Matthew Balch wrote:

Hi,

I am trying to use macros in existing spreadsheets. They work fine if I
create a new spreeadsheet etc. But when I try to use the same macro in an
existing sheet then it doesnt work. Highlights the error.

Simple macro such as:-
ActiveSheet.ShowDataForm

Doesn't work and the debug highlights this line yellow.

Are there some sort of saftey / secuirty settings that might be in place
that are stopping these macros?

Cheers
Matt

--

Dave Peterson