Keep website "Formatting" when extracting table to Excel

[dman78]

I have a table that I am succesfully extracting from a website to my excel, but I am loosing formatting (ie. there are hyperlinks in the table that I need to keep)

Below is the code I have to extract but need to know how to to paste special with formatting.....

  'Make sure it's a blank cell, and if it is dump the data other wise go to the next column after it.
                        If ThisWorkbook.Worksheets("Table_Extract").Cells(RowCount, ColCount).Value = "" Then
                            ThisWorkbook.Worksheets("Table_Extract").Cells(RowCount, ColCount).Value = IECell.innerText
                        Else
                            ThisWorkbook.Worksheets("Table_Extract").Cells(RowCount, ColCount + 1).Value = IECell.innerText
                        End If