Use result of formula in VBA

[tourgis2000]

Hi,

Once again I again I find myself fumbling with basic VBA. I need to hide or unhide a number of columns on each worksheet of a file but the number of columns is different on each worksheet. I have a clculation in my spreadsheet as follows:

="B:"&SUBSTITUTE(ADDRESS(10,A1+1,4),"10","")

This might produce the following:

B:F

How can I get this into VBA thus?

Sub Hide_columns()
    Columns("B:F").Select
    Selection.EntireColumn.Hidden = True
    Range("A1").Select
End Sub

Thanks,

Martin

 

[crimson_b1ade]

replace K6 with where your formula is.

Sub Hide_columns()
    
Dim myColumns As String
 
myColumns = Range("K6")
    
Columns(myColumns).EntireColumn.Hidden = True
 
End Sub

 

[tourgis2000]

Thank you so much: I tried all kinds of varieties of your answer but didn't quite manage to get there.

Martin