UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> UsedRange    
 
   
azizrasul
post Jan 22 2008, 12:11 PM
Post #1

UtterAccess Ruler
Posts: 1,065
From: Faisalabad, Pakistan
I initially export 268 records to a Excel file called Temp.xls, which already exists but which is deleted prior to export.

I have the following code: -

lngRow = ActiveSheet.UsedRange.Rows.Count

However I get a value of 5495. When I open Temp.xls and do Ctrl+End it does indeed go to the 5495th record. Why does this happen?
Go to the top of the page
 
+
« Next Oldest · Access Automation · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 06:52 AM