Set column name as a variable to be used in range

Basically im trying to set a name for my column which will be used in the "Range" but i couldnt seems to do it. Anyone knows why??




Dim lastcol As String
lastcol = "P"

If z = "" Then
Sheets("B").Range("J:lastcol").EntireColumn.Hidden = True
End If

Please Login or Register  to view this content.

It worked thankssss!!