(Solved) – How to calculate excel multiple columns via VBA if last column first cell is blank?

  • by
(solved)-–-how-to-calculate-excel-multiple-columns-via-vba-if-last-column-first-cell-is-blank?

My Excel looks likes (total columns 6) but macro count 5. {last column is mixed with no. and blank cells}

A B C D E 
F G H I J K
L M N O P
Q R S T U V
W X Y Z

I have used range option but it’s only working for single sheet for multiple sheets it’s not working.

colCount = Sheet1.Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Column

This gives me count is 6.
Please let me know for the multiple sheets.

Leave a Reply

Your email address will not be published. Required fields are marked *