Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting formula cells not same as sort of value cells? Yikes! | Excel Discussion (Misc queries) | |||
Formula refers to empty cells even when cells contains data | Excel Worksheet Functions | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |