hello

another (I am sure) banal problem I am not able to cope with.

I need to name a variable named after 3 first characters of active cell.

I tried
dim var
var = left(activecell.value, 3)

i tried also
dim var, var1
var = activecell.value
var1 = left(var, 3)
as suggested in one of the threads

but I always get an error on this line of code

active cell contains text

any help appreciated

thanks in advance