public const

Originally Posted by jocke

HI, i'm trying to declare a public constant in the general selection just as it say's in the ms help section, but excel won't approve of it.

where do i get it wrong?

here's my codeline


public const mystr as string = "testing"

Hi,

You need to do that in a Module, not in Worksheet or Workbook code.

---