I am trying to create a macro that will add the dollar values in a specific
column. The problem I am having is that the number of vaules in that column
vary depending on the worksheet. Ex. Worksheet 1 has 20 dollar values while
worksheet 2 has 60 dollar values.

How can I create a macro that will, autosense if you will, the number of
values in a specifc column and adjust the formula to meet the needs of
different spreadsheets?