Excel 2007 - Clear data table

[RRinTetons]

I have a column input data table with four columns of output. Now I want to change the data in the input column to a data set with fewer members (fewer rows of data).

I cannot for the life of me figure out how to clear the data table so I can chnage it and repopulate it. No matter WHAT I do I get the message about not being able to change part of a table.

I'd *LIKE* to be able to clear the output range and start over, any suggestions?


-
Richard Ray
Jackson Hole Mountain Resort

 

[xlhelp]

Since the results are in an array you must clear all values. Make sure that you do not select the formulas.

Eraser icon, clear contents.


Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents