| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extra Record in Data Range
Hello All,
I have a problem, I am sure that everyone in here has had this problem and I was hoping for some help to solve it. I have checked the groups for a solution but was unable to find anything suitable. Anyway on to the issue.... I have a datarange which retreives information from a SQL Server 2000 database, everything works fine when there is a lot or records returned, the problem occurs when just one record is returned. I am doing a "DataRange.Rows.Count" which returns the correct number for large number of rows but returns 3 for just 1 row (i would have expected 2 as i have headers turn on) see screen shot - the highlighted region is the datarange with one row return, as you can see there is a blank row under the return record. any ideas as to how to not return this record? Thanks Bill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| How do I search a data range for a particular value then collate . | Excel Discussion (Misc queries) | |||
| extend data range formats and formulas | Setting up and Configuration of Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
