Formula on cells
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 |
Formula on cells
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 |
All times are GMT +1. The time now is 05:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com