J
John Wilson
Having a little trouble with this and can't seem to find it in Google.
The following works for ComboBox "TeamPick"
TeamPick.RowSource = "Divisions!B4:B11"
Problem is that I want to use an integer variable in place of
the column letter.
e.g.
Dim i as Integer
i = 5
TeamPick.RowSource should be range E4:E11
I know I could jury-rig this with a lookup table somewhere
but was hoping there was a simpler solution.
Thanks,
John
The following works for ComboBox "TeamPick"
TeamPick.RowSource = "Divisions!B4:B11"
Problem is that I want to use an integer variable in place of
the column letter.
e.g.
Dim i as Integer
i = 5
TeamPick.RowSource should be range E4:E11
I know I could jury-rig this with a lookup table somewhere
but was hoping there was a simpler solution.
Thanks,
John