I have attache a sample Excel Sheet here. I have few questions around this excel sheet.
1> In header, how do i set the Tax Year programatically. The tax year should go in place of [Tax Year] and since its a header
so it should repeat on each page.
2>How do calculate Total of Purchase Price programatically and put it in "Total" row under "Purchase Price" column.
3>I tried to use Cells.Subtotal() funtion to calculate total but, this funtion also puts its own wording which i dont want.
4>What is the third parameter in Cells.Subtotal() funtion indicates? which is int totalList
5>How do i make sure even if i set the columns to autofit, the page should not go out of margin while printing.
6>how do i set Wrapping option on all the cells in worksheet?