View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BradF BradF is offline
external usenet poster
 
Posts: 6
Default getting the sum of the last 20 cells

Hi all,

I am a newbie to Excel VBA. I have a question for the
experts here. I have a table which keeps adding row entries
and it increases vertically. I want to get the sum of the last
20 entries (always the last 20 entries). How do I do that
and which command do I use? Thanks in advance.
Red