[Solved] setting a value

[comical]

Hi
I would prefer to use a named range instead of column letters, so instead of

range("A3").value=

I could set a named range for column A 'Col_A'. Im not sure how I could specify putting a value into row 3 of `Col_A` though

does anyone know of a way please?

this might not be the best way of naming columns just to make code easier to read/troubleshoot/maintain

thanks!

 

[comical]

and now finally my google search skills kick in

Range("Col_A")(3) = 123

 

[shamimarita]

and now finally my google search skills kick in

Range("Col_A")(3) = 123

Dear Comical,

It's good to see that you solved your problem so efficiently, congratulations.