I am trying to write a macro that pulls data into my first workbook from my second workbook. Below is my code. Rather than linking the cell value to the second workbook, the formular1c1 portion in the loop is simply returning, as an example, ='[HR1]Sheet1'!R31C6. I am looking for it to return the actual value which should be in a formula such as ='[HR1]Sheet1'!F6. Any advice?

Please Login or Register  to view this content.