Code working on one sheet but not on another

[jpe1]

Hi guys, ive written a code, it works perfectly on the enthalpy balance sheet, the code for this can be found in the Coefficients_Q module. I have made a new sheet Enthalpy and copied the code and changed the cells appropriately into module 1 but it no longer seems to work. Can someone please tell me why?

[Kenneth Hobson]

What does not work mean?

It has a Stop which is not a command word. If one wants to exit a sub use Exit Sub.

I would use a Select Case rather than multiple IFs. A lookup table would be a better route. Select, Selection, Activate, and such are seldom needed. When repeating code, if a pattern exists, it is easier to maintain one Sub and pass the changing parameters.

[Winon]

Hello jpe1,

Your Code for the enthalpy balance sheet refers to Range A8 followed with an Offset of -5, while your Code for the enthalpy sheet refers to Range A6 followed with an Offset of -5. Since the Start Cells are not the same, you should also change the Offsets accordingly. So the Code for the enthalpy sheet should look something like below, etc.

Please Login or Register  to view this content.

And so on.

Regards.

[jpe1]

Thank you, ive changed it, ive tried running the code but it keeps saying cant loop without a do, there is a do statement at the beginning but the code dosent seem to use it.