Hi,

I'm trying to design a simple spreadsheet that does some accounting
calculation and then represents them in a variety of charts. I'm
simply using macros through demonstration rather than coding. I was
wondering how one might be able to use VBA to detect the bottom right
most range Y coordinate(X letter is predertimed - number of fields in
spreadsheet) so the macro will run correctly regardless of how many
rows there are?

Thanks ahead,
Altein




--
altein