Calculating in Excel with VB

[gaby5]

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

[BrianB]

To calculate rows, choose a column that has something in the last row and use something like :=
MyRowCount = ActiveSheet.Range("A65536").End(xlUp).Row

As for the rest, I suggest you use the macro recorder to get some code and copy/paste to a new message with a note of any problems you get running it.

[gaby5]

Hello Brian,

Thanks for the information, but what I wanted to know was that even though if I donno the range (b'coz i don't wnat to open the excel sheet)it automatically calculate the range where the data is present and put that range in VLookup formula which can be used for calculation..

Thanks

[opus]

If you don't open to file, you don't have the data, and you don't have the VBA-code (since it would be part of a EXCEL-file).