LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Naz Naz is offline
external usenet poster
 
Posts: 85
Default Excel DataForm not shwoing right data

Hello again, I'm sure I posted this about 10 minutes ago but its not come up
weird.

I have recorded the following code

Sub ShowDataEditForm()

Range("A5").Select
ActiveSheet.ShowDataForm

End Sub

But for some reason the form returns data from row 2, just a sheet heading.
Whereas the headings are in row 5 and the data below that.
Where am I going wrong? I've tried changing the first line to
Range("A5:I5").select but still the same result


--

_______________________
Naz,
London
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel DataForm not picking up correct list Naz Excel Programming 1 June 1st 05 01:40 AM
How to activate "new" tab in Dataform in EXCEL through VB shajueasow Excel Discussion (Misc queries) 2 May 1st 05 01:21 PM
Dataform Mark Excel Programming 3 February 14th 05 12:59 PM
dataform Enrique Bustamante Excel Programming 1 August 26th 04 01:30 PM
custom dataform jim clark Excel Programming 0 July 29th 03 04:36 PM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"