VBA: select column through drop down list (Excel)

[zeno]

Hello,
I would like to select data from 2 different columns in Excel, depending on the column selection in a drop down list (e.g. column A or B) defined in another named cell (e.g. Listcell). So I select the column from that list and then will make calculations on the chosen column.
Can you please help me with the VBA code to execute this action.
Thank you.

 

[Smitty]

Have you tried recording a macro?

 

[Marcelo Branco]

If you want to select the entire column, maybe

If Range("ListCell") <> "" Then Columns(Range("ListCell").Text).Select

M.