VBA error

[fred2028]

Hi,

I am running a report and get this error

Run-time error 1004: Application-defined or object-defined error

Takes me to the line .Offset(i, 4).Value = .Offset(i, 3).Value - .Offset(i, 2).Value in my VBA function that is

Please Login or Register  to view this content.

Firstly, how do I start debugging based off of that error? It seems super general. Secondly, how can you get an error from Offsets? Isn't it just moving around in the cells and subtracting?

Where should I look for the source of the error? Thanks.

[davesexcel]

Does that line of code get a value?

What is the code supposed to do?

[StevenM]

If the range

Please Login or Register  to view this content.

is a series of cells (as opposed to being a reference to one cell), then each offset:

Please Login or Register  to view this content.

will be a range with the same number of rows and columns as the original Range("avgStart").

[fred2028]

Hey Dave or steven, can I send you the excel sheet via email? I'd rather not post it publicly. If you want, you can email me fred2028@gmail.com so I can have your email. Thanks