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.
|