understanding code

Hi there,
Can someone explian to me this line of code in eglish specially after the .Count /14-1

Please Login or Register  to view this content.

Hello karinos57,

The UsedRange method returns a rectangular range of cells on the worksheet (Scoresheet) that have been used. The Count property returns the numbers of used cells on the worksheet. The total number of cells is divided by 14 and then 1 is subtracted from the remainder.