Hi guys,
I have got several sets of data (some of them are are assigned to #value!) and I want to use the record macro function in order to convert the sets of data into stock charts. The sets of data are arranged in the following way:

time #VALUE! #VALUE! #VALUE! #VALUE!
Open #VALUE! #VALUE! #VALUE! #VALUE!
High #VALUE! #VALUE! #VALUE! #VALUE!
Low #VALUE! #VALUE! #VALUE! #VALUE!
Close #VALUE! #VALUE! #VALUE! #VALUE!
time 31.03.2013 30.03.2013 29.03.2013 28.03.2013
Open 1,04163 1,04163 1,04119 1,0443
High 1,0419 1,04163 1,04267 1,04569
Low 1,04026 1,04163 1,0401 1,03963
Close 1,0409 1,04163 1,04163 1,04114

Another problem is that the stock charts function does not recognize the #value!

thanks a lot guys