View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob G Rob G is offline
external usenet poster
 
Posts: 2
Default Referencing a Column in a Selected Range of Columns

Hi,

Using VBA code, how could I select a bunch of columns that may or may not be
continuous, and return a sum (or any function) from each column?

For example, I select Columns A,B, D, and E. The procedure (maybe in a
msgbox) returns:
A total = 100
B total = 200
D total = 150
E total = 175

Thanks for your help.

-Rob

p.s. The specific problem I am having is returning which column I selected.