I am dynamically populating a blank sheet with contents from another sheet. I want to sum certain columns. Here is what I am using.
cr = Sheets("X").Cells(1, Columns.Count).End(xlToLeft).Column
For c3 = 1 To cr
If Left(Sheets("X").Cells(1, c3), 1) = "#" Then
rall =...