Any idea what I am doing wrong he

Sub TestRangeValue()

Dim dValue As Range

Set dValue = Application.InputBox(prompt:="Enter Cell Reference to Ge
Color Value For", Type:=8)

ActiveCell.Value = "=TSColor(" & dValue & ")"


End Sub

TSColor is a function I created to pull the background color in numbe
format so it could be sorted by color. I am trying to get this to typ
the formula for them (kind of a teaching thing for new formulas) whe
they select the range to use. I am getting the value in the range
select and not the range itself. If I enter C7 into cell C7 this work
to put the formula in cell C8 but if they select C7 and it is blank i
returns '=TSColor()'

Thanks for any help

--
stvgarne
-----------------------------------------------------------------------
stvgarner's Profile: http://www.excelforum.com/member.php...fo&userid=2059
View this thread: http://www.excelforum.com/showthread.php?threadid=53346