Almost ready to pull my hair out over this one...

Why can't I get the following code to assign the linkedcell value of an
activex combobox????? After running this code the linkedcell value
remains blank.

Sheets("Row Template").Activate
ActiveSheet.ComboBox1.LinkedCell = Range("Offset(insertpoint, -6, 1)")

Yet if I change the code following the '=' symbol to a direct reference
(as below) it works:

Sheets("Row Template").Activate
ActiveSheet.ComboBox1.LinkedCell = "A1"


Am I using the offset method incorrectly???? How do I do this? Please
please help me!


---
Message posted from http://www.ExcelForum.com/