bdb1974

Hi Bob,

Not sure what happened there. I've seen it once before: seems like a glitch in the vBulletin software.

I can't see how to move it to be a post and as it doesn't seem to on the board I'd be inclined to post it again.

Regards

BDB, about the refEdit control. The Text returned is an address your line sett

Set myRange = RefEdit.1.Text
should be
Set myRange = Range(RefEdit1.Text)

Hello BDB,

After having reviewed your posts with Donkey Ote and seeing this quote...
"After, my values are generated, it would be really nice to not have the formulas be left in all the cells. I only need the values."
I believe the best answer is to replace all the formulae with a VBA macro. To do so would require seeing your workbook. I could write a macro to fill in the gaps, but in the long run it would be best to convert everything now. I am using Excel 2000 and 2003. If you are using Excel 2007 then be sure to save the workbook in Excel 2003 format. If it has confidential information, you can email me at LeithRoss@gmail.com

Sincerely,
Leith Ross