Cannot Launch Data Form with Macro

[stevewater]

I?m trying to get the Xl ?Data Form? to work from a evoked macro, however it always wants to default back to cell (A1), even when my code directs it to (A20)

Range("A20").Select
ActiveSheet.ShowDataForm

[mdmackillop]

Hi Steve,

Welcome to VBAX.

You're doing better than me!, I get nothing at all, but continuing to investigate.

BTW, if you wish to post your workbook, click on Go Advanced below the reply box, and then Manage Attachments. You can attach zip files etc.
Regards
MD

[mdmackillop]

Create a range name "database" for your data

http://support.microsoft.com/default...b;en-us;213835

[stevewater]

Thanks for the Link its working perfectly



Mission completed