Maximum Row returns 1 instead of 1000
-
-
-
Re: Maximum Row returns 1 instead of 1000
Is your data in a worksheet with the name "Sheet1"?
-
Re: Maximum Row returns 1 instead of 1000
Yes "Sheet1"
-
Re: Maximum Row returns 1 instead of 1000
Post your workbook.
-
Re: Maximum Row returns 1 instead of 1000
Your code works fine for me.
Since we don't have the benefit of seeing alll of your code . . . just a guess.Did you, by change, use an incorrect column reference (i.e. you used "A", but needed "B")?
Are all of the 1000 entries in column-A?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!