I have a userform which allows people to select a column and places tha
value in cell iv65536. I have then named this cell as WhichColumn. Th
column as a reference changes regularly and I used to have to go int
the code to change the offset value.

It is part of an IF statement

Old code
Else 'if the charge exists

ActiveCell.Offset(0, 23).Range("A1").Select
ActiveCell.Range("A1,F1").Select
Selection.Copy
Worksheets("Sheet2").Select
c.Offset(0, 1).Select
ActiveSheet.Paste
Worksheets("Sheet1").Select
ActiveCell.Offset(1, -23).Range("A1").Select
vSourceCharge = ActiveCell.Value
End If

What i want to do is set the column reference to refer to the value i
cell iv65536 which has the value eg Sheet1!$S:$S.

Does anyone know how to refer to a named range or get the contents o
that cell and use in a relative reference?

thank

--
rbekka3
-----------------------------------------------------------------------
rbekka33's Profile: http://www.excelforum.com/member.php...fo&userid=1403
View this thread: http://www.excelforum.com/showthread.php?threadid=27442