Help.. I know its simple but annoying me
I'm trying to count the number of columns betwen to rangenames,. Each range name refers to a single cell.
e.g.
Sub test()
Application.Goto Reference:="Start_Outline"
Application.Goto Reference:="Start_TaskName"
int_col = 3
End Sub
i.e trying to make the variable int_col refer to the number of columns between Start_Outline Start_TaskName rather than a constant.
Many thanks
Modfish
I'm trying to count the number of columns betwen to rangenames,. Each range name refers to a single cell.
e.g.
Sub test()
Application.Goto Reference:="Start_Outline"
Application.Goto Reference:="Start_TaskName"
int_col = 3
End Sub
i.e trying to make the variable int_col refer to the number of columns between Start_Outline Start_TaskName rather than a constant.
Many thanks
Modfish