Selecting a column with a declared variable

[dac005]

Dim c1 As String
c1 = column1.Value (lets say column1.Value = B)
Columns("c1:c1").Select <----- bug happens here


Please help me!

 

[MrKowz]

Welcome to the forums!

Try:

Dim c1 As String
c1 = column1.Value (lets say column1.Value = B)
Cells(1,c1).Select

 

[dac005]

Thank you MrKowz! You definitely helped me out.

Cells(1, c1).Select
Range(ActiveCell, ActiveCell.Offset(50, 0)).Select <--- i added this to select the column

Thanks again.

 

[MrKowz]

Try:

Cells(1,c1).EntireColumn.Select