It has been a while since i used VB, i need to create a code which helps in calculating number of rows in Excel and copy that number to a formula and then to do the calculation. The calculated number should be pasted in different excel file and then the formula which exists need to have this number for calculation, could u please advice on this..

Thanks