hi there

my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only
using 1 (cannot set to one as in future this will be dynamic...)

any ideas?

go down to row 5002 and select the entire row and then hit delete.
now try the code again

J



Buffyslay wrote:

hi there

my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only
using 1 (cannot set to one as in future this will be dynamic...)

any ideas?

WhytheQ wrote:
go down to row 5002 and select the entire row and then hit delete.
now try the code again

J



Buffyslay wrote:

hi there

my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only
using 1 (cannot set to one as in future this will be dynamic...)

any ideas?

you've probably got blank rows = no value, but excel still counts them
(cause there has been some operation made on this row in the past)

go to:
http://www.contextures.com/xlfaqApp.html#Unused