Paste formula into new row in excel using C# using get_Range

Question

1 A  B  C   D    E   F
2          =D1  =E1   
3           X    x

Some of the cells in row 3 are blank, i want for perticular range("D3","E3") formula to be pasted from row 2

plz do needful, thanking you...

LOL......are u gonna accept answers?? – Sangram Dec 30 '10 at 12:01 — Sangram, Dec 30 '10 at 12:01

NirMH · Answer 1 · 2011-07-12 13:45:41Z

up vote 1 down vote

use the Value2 of the range to get access to the actual formula per cell.

you can iterate over the range cells using foreach (Range c in Source_Range.Cells) (assuming Source_Range is D3:E3 cells.

answered Jul 12 '11 at 13:45

NirMH
2,2321130

@Smack: did my answer help you? if yes, please accept it – NirMH Aug 2 '11 at 6:39

add a comment |

1 Answer 1