Ago
03-11-2008, 02:44 PM
when my macro copys in a value to my cells and the value starts with = (equalsign), excel will give the errormessage =name? in green text.
how can i disable this?
i dont use any formulas anywhere in the sheet so i dont mind blocking them all, but the problem is only occuring in column E.
same thing happens when the value is numbers only, it will ask me if i want to convert it in to numbers (currently set to text).
what i would like to do is to tell excel and microsoft i know what im doing but with more cussing involved :)
any ideas?
EDIT: to give you guys some background info, the macro is a delimiter-script that seperates the values from column A to nine other coulmns
how can i disable this?
i dont use any formulas anywhere in the sheet so i dont mind blocking them all, but the problem is only occuring in column E.
same thing happens when the value is numbers only, it will ask me if i want to convert it in to numbers (currently set to text).
what i would like to do is to tell excel and microsoft i know what im doing but with more cussing involved :)
any ideas?
EDIT: to give you guys some background info, the macro is a delimiter-script that seperates the values from column A to nine other coulmns