difficulty with ClearContents,

[EDUCATED MONKEY]

WIN XP professional office 2003 IE 8<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Hello I am having some difficulty with ClearContents, <o></o>
<o> </o>
The problem arises when I clear the contents of column A to make ready for new data, if I did not clear the column then I would run the risk of old data remaining as the row depth varies<o></o>
<o> </o>
The problem I am having is the cell references to column A on the same worksheet go missing I have tried using both forms of referencing it happens with both<o></o>
<o> </o>
Can some please tell how I get around this problem I am sure it must be something very simple<o></o>
<o> </o>
<o> </o>
To give an example <o></o>
<o> </o>
<o> </o>
after clear column A =FIND(":",#REF!,1) origonally =FIND(":",A1,1)<o></o>
<o> </o>

 

[Jonmo1]

It sounds like you're deleting, not clearcontents..

 

[Ruddles]

.ClearContents only empties the range, it doesn't destroy it.

Show your code?

 

[EDUCATED MONKEY]

spot on thats the problem called the wrong macro that deleted not cleared