Hi Guys,

I have been asked to automate some work to an Excel Workbook.
In the workbook some columns have been added with formula's and then hidden.
I am looping through the columns and when I find a certain cell of that column empty, I know that this is the next column to work in. What I want to do is unhide the column in code.
If I write:
Columns("EC:EC").Select
Selection.EntireColumn.Hidden = False
All works ok but what I want to write is
Columns(LoopColumnCount & ":" & LoopColumnCount ).Select
Selection.EntireColumn.Hidden = False
where LoopColumnCount is the variable I am using to loop through the columns. at the end it may = 122
How do I convert the value 122 into the correct cell ref, i.e. "EC" , so I can use Columns("EC:EC").Select
Hope this makes sense.

Thanks for your help,

Steve.