Declaring Global Constant

Hi,

I'm having trouble declaring a global constant. Here is the code line which is written at the top of a module (.row is highlighted when it errors):

Public Const PupilCount As Long = Sheet9.Range("A65536").End(xlUp).Row

Also, when is a global constant initialised? When the workbook is opened?

Cheers

You can't have a constant that's the result of a variable by its definition.

It has to be fixed, so in your scenario you'd Dim it rather than Const it. It would only be a constant if it's a fixed number so:

Public Const PupilCount As Long = 10