Posts: n/a

ShowDataForm method

I recorded the following macro

Range("A1:B1").Select
ActiveSheet.ShowDataForm

It works on a new unsaved workbook, but I get the error
message "ShowDataForm method of worksheet class failed"
when I run it on a template. Please help.

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
modified dietz method	Bonnie	Excel Discussion (Misc queries)	0	January 21st 05 05:37 PM
What is the quickest method to insert & name multiple worksheets .	clyonesse	Excel Worksheet Functions	0	January 20th 05 06:15 PM
Calculation Method for Quartiles	Mike57	Excel Worksheet Functions	2	January 20th 05 01:49 AM
method and function	mango	Excel Worksheet Functions	0	December 14th 04 11:51 PM
Method to increment value in data field?	Karl H	Excel Discussion (Misc queries)	1	December 4th 04 05:25 PM

All times are GMT +1. The time now is 04:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us