ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   -4127 is created by my macro.(Bug?) (https://www.excelbanter.com/excel-programming/362042-4127-created-my-macro-bug.html)

Ctech[_141_]

-4127 is created by my macro.(Bug?)
 

Hi guys,

I believe that I have a bug in my macro. A certain cell in my
spreadsheet gets the value -4127 everytime I run the macro..

However there is nothing in the macro which says that it should print
this number in this cell...

Anyone know why this can happen?


If you want to see my file, I have attached the Workbook in a zip
file.
Workbook is protected with the password ("Result")
Error happens in cell "L66" on the template sheet.


Thanks guys


+-------------------------------------------------------------------+
|Filename: Under dev - Project Form v 1.7.3 - Protected.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4797 |
+-------------------------------------------------------------------+

--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=544214


Ctech[_142_]

-4127 is created by my macro.(Bug?)
 

Is there really knowone that have encounter such a problem before

--
Ctec

-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=54421



All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com