Variables in range object

[swankyg]

Hi, I'm trying to create a macro that will format data in a whole column, with the user typing the column letter into an input box.
I'm trying to use a variable (set via an input box) to pass the column letter to the data object.
Can you do this (I haven't been having any luck) and if not can you suggest how to select a column selected via user input?
Thanks!

 

[Joe4]

Welcome to the Board!

Here is a little example to show you how you can select an entire column based on an input value.

Sub Test()

    Dim myCol As String
    
    myCol = InputBox("Enter the column letter")
    
    On Error GoTo err_chk
    Cells(1, myCol).EntireColumn.Select
    On Error GoTo 0
    
    Exit Sub
    
err_chk:
    MsgBox myCol & " is not a valid column"
    
End Sub

 

[swankyg]

Great! Thanks a lot, just what I was looking for.

 

[Joe4]

You are welcome!