VBA statement: public

public declares a global variable

In order to declare a local variable, dim is needed.