Hello all
I hope you can help on this
I have data values that starts in [Sheets("DashBoard").Range("C2")] with multiple rows and multiple columns.
Both the Rows and Columns can expand or contract in size every time the report is run
Using VBA how can I find the last column with data then sum the total of each row after the last column of data
Can anyone please help on this
I hope you can help on this
I have data values that starts in [Sheets("DashBoard").Range("C2")] with multiple rows and multiple columns.
Both the Rows and Columns can expand or contract in size every time the report is run
Using VBA how can I find the last column with data then sum the total of each row after the last column of data
Can anyone please help on this