At the moment I have set up a spreadsheet with 150 formulas across and 3000
down - then when I paste my data into the first blank worksheet - I get a
result which I can use as percentages - the only problem with this is that
the file is 40mb - and takes a while to paste data/manipulate and would be
great if a macro could be created to automatically work out how many rows
are required for the data pasted rather than the current set up.

Thanks,

Colin

"Trevor Shuttleworth" wrote in message
...
Colin

not sure about the best way to do what you want ... but is the objective
to
get 150 zeros or ones depending on the value of the first cell ? If cell
1
is 1, then cell 2 becomes 1; as cell 2 is now 1 then cell 3 becomes 1;
etc.
Got to be a quick way to do that I'm sure !

Regards

Trevor


"CS" wrote in message
...
I have some VBA code which selects and copies a range of cells - 150 at
a
time - I then want to be able to run a fomula on these 150 values and
paste
them into a new worksheet.

How would I go about running a formula on the numbers stored in the
clipboard - is it best to paste them first then do the formulas or is it
possible to let excel do the maths in its 'head'!?

(The formula I want to use is simple enough - If previous cell = 1 then
1
else 0)

Thanks,

Colin