Variable Last Entry

[Aydinz]

i am trying to creat a macro for a template but i have various functions in the template which need to have the last entry co-ordinate entered into them. for example the information for this template can range from 200-600 users and in some instances i need to have a =sum function that adds up the total of all the users details regardless whether there are 200 or 600 users. so an example is =sum(c2:c234) but i need the formula to be intelligent enough to detect whether there are 234 entries or 456 entries or any amount of entries.

Any Help would be great. if i havent made myself clear please ask me to specify certain things and i will do my best to try to clarify

Cheers

[mikerickson]

Aydinz,

Welcome to the forum. I'm going to move this thread to the Programming sub-forum, where VBA and macros are the emphasis.

Have you looked into using Dynamic Named Ranges, which expand to include new data?

Could you attach a sample workbook, since it seems that the heart of your problem relates to how to refer to your data lay-out?

[davesexcel]

Maybe this would work for you...

Please Login or Register  to view this content.