On active row select col"A" and change to upper case

[gregfox]

On any selected column using VBA I would like to select whatever is in column “A” and change it to CAPE.
Thanks!

Excel 2007
PC

[Fluff13]

Will you be selecting 1 row or multiple rows?

[sourabhg98]

Try using this code -

Please Login or Register  to view this content.

So select any cell and run this code. The corresponding value from column A would be converted to upper case.
You can use a button or even a keyboard shortcut to run the macro. In the sample workbook attached I have assigned the macro to "Ctrl + Shift + C" key combination.

Excel Forum 1256.xlsm

[sourabhg98]

As rightly asked by Fluff13, if you need to do the same for multiple row selection then use the following code-

Please Login or Register  to view this content.

Excel Forum 1257.xlsm

[Winon]

Hello gregfox,

Here you go;

Please Login or Register  to view this content.

Regards

[Winon]

Hi gregfox,

Or you could use;

Please Login or Register  to view this content.

[gregfox]

Mant thanks!

[Winon]

Hello gregfox,

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.