Reference error

[Av8tordude]

Can someone assist with this error...

I created a text file and naming the file with the cell value. However I'm having trouble writing the reference code below.

Public Const ObscureFile$ = Sheets("Security").Range("IQ2") & ".Log"

 

[RoryA]

You can’t have a constant that uses a cell value, since that is inherently variable.

 

[Av8tordude]

Is there another way that I can write this?

 

[RoryA]

You'll have to use a variable and initialise it in a routine.