I'm trying to import a worksheet from a closed workbook, but I also want the comments. This is what I'm using so far. This works for getting the data from the cells, but not the comments. I did not write this code. I found it on the WEB. I'm open to suggestions. Can anyone help me.

Sub PullInSheet1()
Sheet2.Cells(1, 1) = "= 'G:\[firmware.xls]Sheet 1'!RC"

With Sheet2.Range("A1:T130")
'If the cell in Sheet1 of the closed workbook is not _
empty the pull in it's content, else put in an Error.
.FormulaR1C1 = "=IF('G:\[firmware.xls]Sheet 1'!RC="""",NA(),'G:\[firmware.xls]Sheet 1'!RC)"
'.Comment.Text = "='G:\[firmware.xls]Sheet 1'!RC"
'Delete all Error cells
On Error Resume Next
On Error GoTo 0
'Change all formulas to Values only
.Value = .Value

End With
End Sub


Thanks

HuggyBear