CODEWITHSUNDEEP
c#visual-studioexcelvstoadd-in
Smack
Smack

Reputation: 946

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

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...

Upvotes: 0

Views: 480

Answers (1)

NirMH
NirMH

Reputation: 4929

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.

Upvotes: 1

Related Questions