Trying to sum a range of cells on different sheet, where the upper and lower rows changes. I'm getting a the syntax error "run-time error '1004': application-defined or object-defined error" for the following line of code:
Re: assistance with syntax error (teaching myself VB)
Hannes, many thanks for the reply. I'm trying to build a model that to begin with will track inventory uses and at the same time calculate an average cost of inventory in stock. I'm running to issue and the average cost calculation. I have attached a stripped down version of the model . On the "batch details" tab there can be several different batches of raw material sitting inventory, but current production would only be pulling from one batch at a time - average cost of remaining inventory would then be recalculated every time inventory is used.