Group,
I'm using the following code to determine the last row and column i
my spreadsheet. Unfortunately the returned numbers are greater than th
true last row/column. I'm about 100 rows past the last used, 115
instead of 1050 and I'm about 20 columns past the last column. I
there something unseen in my blank columns and if so how do a resolv
this issue.

With Worksheets("Sheet A").UsedRange
LastRowCurrent = .Rows.Count
LastColCurrent = .Columns.Count
End With


Ton

--
ajociu
-----------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...fo&userid=1769
View this thread: http://www.excelforum.com/showthread.php?threadid=47365