Hi again!
I want to create a dynamic range in column K. The static range is Range("K2:K821")
The dynamic range I then use for counA and CountIF
Since the last row in column A always is nonblank, i thought using offset 
Please Login or Register  to view this content.
the last row is correctly set to 281, but when I put it in the range, then select row 2821 and only 1 blank cell
please help me out
Thanks in advance
Best regards
//Peter