>I have no problems getting information into excel. What I want to do is get information out of excel and store it in a memory variable. I want to create a formula and then retrieve the results. I can create the formula and excel calculates it without any problems. I just cannot get the information out.
>
>Thanks
>Todd
Doesn't .Cell(row, col).Value return the current value?
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)