ClulessChris
IS-IT--Management
Hi
I'm using the following to get a range of used cells in a column
Trouble in that on times (I don't see any reason for this) This method will count far more cells in that col that those used, other it works as I expect and only count those cells used.
Can anybody explane this to me?
many thaks for you input.
Everybody body is somebodys Nutter.
I'm using the following to get a range of used cells in a column
Code:
Range("A1").select
' This next line should find the last used cell
Range(Sellection,Selection.End(xlDown)).Count
Trouble in that on times (I don't see any reason for this) This method will count far more cells in that col that those used, other it works as I expect and only count those cells used.
Can anybody explane this to me?
many thaks for you input.
Everybody body is somebodys Nutter.