How to Select sheet name and selection.value together?

[JJGF]

This works:

Columns(Range("sheet1!AE2").Value).Select

but instead of AE2 I want to use selection.value

Tried this but doesn't work:

Columns(Range("sheet1!").selection.Value).Select

[TMS]

Maybe:

Columns(Range("sheet1!" & selection.Value).Select

Regards, TMS

[patel45]

Sub b()
Sheets(1).Select
Columns(Selection.Value).Select
End Sub

[TMS]

Sheets("sheet1").Range(Selection.Value).EntireColumn.Select

Note that an easy mistake to make is to press Enter to confirm the value in the cell and then try and run the macro.

More secure is, for example:

Sheets("sheet1").Range(Range("C8").Value).EntireColumn.Select

Regards, TMS