error 6

Hi, I have to calculate the average of each column values at sheet 2 and store it to sheet 3. While I am running the code, it ends with Runtime Error 6 Overflow. My code is given below. Sub AvgCal() Dim ws2 As Worksheet Dim ws3 As Worksheet Dim count As Integer Dim sum As Long Dim avr As Long...

I am trying to do some calculation with sumifs and criterion. I need to do SUMIFS of the first column (jRange) and to divide it by SUMIFS of the second column (lRange) several times (based on different criterion). And put a result to the certain cells. I have found a solution for that (probably...

Hello Guys! I am having a problem with my code below. This code extracts data from a text file. The part where the error occurs is on the 'Converts the quantity from string to integer data type part of the code. It returns an overflow error. It works fine for text files with lines up...