I am looking to define an efficient way to define these number of variables.

Dim sumCol31 As Long, sumCol32 As Long, sumCol33 As Long, sumCol34 As Long, sumCol35 As Long, sumCol36 As Long, sumCol37 As Long, sumCol38 As Long

Dim sumCol39 As Long, sumCol40 As Long, sumCol41 As Long, sumCol42 As Long, sumCol43 As Long, sumCol44 As Long, sumCol45 As Long, sumCol46 As Long

Is there any way to optimize this?

Your help will be highly appreciated.

Thank you