VBA I think it is simple but

[Endeavouring]

Hi

I have a simple user form with a refedit field to select a column , and an option button (optionbutton1) I then want to insert a new column to the right of the column selected by the refedit if the value of optionbutton1 = True

I have tried things like
If optionbutton1.value = True Then
Range(RefEdit1.Value).Column
Selection.Insert Shift:=xlToRight

but then it falls over at the .column

I then ultimately want to fill that column with the length of the data in the cell to the left, but my initial problem is getting the value of the refedit to insert the column.

Thanks

 

[Endeavouring]

VoG

Thanks very very much