Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formula...
I want to make a "special copying" of a formula in excel.
There it is... I Have Data in these cells for example : A1, C1, E1, G1, I1, K1, L1... you understand the patern I guest. I want to copy all these value, in one column.. Like put all the value with a "=Formula" that I can copy in A25 to A500 for example. So retrieve the A1, C1, E1, G1.... value in A25,A25,A27,A28 ... cells. thanks! Marc-André |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formula...
M-A
I am not sure if this is what you want, but the following code will take the value in every other column of row 1 and put them in a column, starting at the active cell. I am not sure what the limits should be on the number of columns, so I arbitrarily run through the first 21 columns. Sub test() For i = 0 To 20 ActiveCell.Offset(i, 0).Value = Cells(1, 2 * i + 1).Value Next i End Sub Also, your example of A25 to A500 indicates a potential problem. Since you restricted to 256 columns, and you are only using half the columns, if you start in A25 you can't have enough data to go beyond ~A150, as I understand it anyway. I hope this helps. Good luck, Ken Norfolk, Va |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a formula | Excel Worksheet Functions | |||
copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
Copying a formula | Excel Discussion (Misc queries) | |||
copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
Copying formula | Excel Discussion (Misc queries) |