Macros

  • Thread starter Thread starter BAS
  • Start date Start date
B

BAS

hi,
I would like to know how to define a macro that checks column A,
(1) if non-empty, adds all the values present in it
(2) if empty, jumps to column B and adds the values present there.

I tried it out but with no success. Can somebody help please?
Its pretty urgent.

Thanking you in advance.
 
Sub Addcolumns()

total = WorksheetFunction.Sum(Columns("A"))
If total = 0 Then
total = WorksheetFunction.Sum(Columns("B"))
End If

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Simple Macro 1
Macro to find specific row on database/worksheet 3
find last non empty cell in a column and display value in msgbox 7
Macro storing as a date? 11
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Sorting, replacing data 1
A data validation question 1

Back
Top