How to stop formula from appearing in VBA generated table

[awoolfe]

I am using VBA to generate a table.
I do not understand why a formula is showing in one of the columns. It is also an incorrect formula so it mucking up the table. As I made this worksheet up a while ago, I cannot remember how I got the formula there in the first place.

The problem:
At the start, on the worksheet there is only the heading of the table and no formula in any column (nor any values).
I am using two categories on a userform to prefill the data from another table in the spreadsheet using VBA.
However, once I click on the two categories and the table data is populated, an incorrect formula pops up in one column. This over-rides the vba.
When I click the userform "new", all rows except for the headings go away. At this point in time there is NO formula in any column.

I tried deleting the table and making a new table with the same headings (and NO formula). However, when I used my userform and table data was populated, the formula ALSO appeared.

Any ideas on why this is occurring, and more importantly how I stop the pesky formula from appearing?

Thanks

[Sintek]

Without a sample file...It is a wildcard guessing game...
Must be reasoning in your code...

[awoolfe]

Thanks sintek.

I have worked out the error is because the table it is copying from has the formula in it.

This is the current vba formula:
T_ORIGINAL.ListColumns(1).DataBodyRange.SpecialCells(xlCellTypeVisible).Copy Destination:=T_VBA(1)

What do I need to change in this formula so it copies the value only in the original table and not the formula?

Thanks

[Sintek]

Will have to incorporate...Untested...

T_ORIGINAL.ListColumns(1).DataBodyRange.SpecialCells(xlCellTypeVisible).Copy
T_VBA(1).PasteSpecial xlPasteValues

[awoolfe]

Thanks sintek. That formula works perfectly!

[Sintek]

Glad to have helped...Tx for rep +