VBA Codes Not Working In A New Document

[jpe1]

Hi guys,
A while ago a wrote a few codes, at the time they worked perfectly. I have copied these codes into a new document but for some reason keep getting VALUE and im not sure why.

[TMS]

At the risk of sounding harsh, you've not given us much to go on. Some nebulous code used to work in one document (or possibly, several documents) but doesn't work in a new document.

What does the code do? You might consider sharing it and maybe heed the suggestion in the yellow banner



Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jpe1]

Hi, ive attached a copy of the workbook. The cells ive highlighted in red contain the functions which ive coded.

[Greg M]

Hi there,

At first glance:

Please Login or Register  to view this content.

The log of a negative number is undefined.

I haven't paid any attention to how the values are calculated, but the overall problem might be related more to the input data than to the code.

Regards,

Greg M