Hello All! I started writing Macros a couple weeks ago.
Currently I've managed to write lots of code without using "range" at all, using for example Cells(row, col) references instead.
Now I wish to transform my code from working on defined columns to whichever is selected.

I'm having a hard time transforming the following code ..

Range("L:L") = [index(Upper(L:L),)]

.. to using a Range defining the active(cell.)column but, with an offset of +1 (ie, I wish to target the column to the right of the currently selected one)
its the combo of 'range', 'activecell' and 'offset' which is throwing me off as I haven't made use of them previously.

Thank you very much for your time and patience !
Best regards,
Kris