You can't, you have to clear the data in the source cell(s).

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Regina" wrote in message
...
None of this is working. I am not very good in VB so please bare with me.
I
think some of my terminology was wrong in the first question that I asked,
therefore I am sure that is why this is not doing what I want. I said I
wanted to clear the constants and leave the formulas. What I am trying to
do
is clear data that is in a linked cell from a worksheet within the same
workbook and retain the links. Thanks,
--
Regina


"Regina" wrote:

The subject line is the error message I get when trying to run the
following
code. When I hit debug, it highlights the line that starts with "set r -
range...". What I am trying to do is clear the constants but leave the
formulas in the "D7:E125" Range. Help!!!!

' Sub clear_part2()
Dim r As Range
Set r = Range("D7:E125").SpecialCells(xlCellTypeConstants)
r.Clear

End Sub
--
Regina