convert to table but loose all macros ?

[littlepete]

Hello,

I can see the advantages for an excel table, i've tried it before, but all the articles give always examples that belong
to the mathematics and statistics not to an address list, or text containing list...
when i try to convert to a table i immediately see that my macros dont work anymore...

is there a way to keep all my functionality and convert to a table or is that a no go ?

thanks for your advice !!!

 

[BSALV]

i'm until a certain level a big fan of listobjects, but indeed they are a little more difficult to handle, but once you know the trick ... .
When you add new data, you only have to say with ".listrows.add.range.range("A1")" and you know the topleftcell of your new listrow.
You don't have to seek for the lastrow, etc.

What is your major problem with VBA and listobjects ?
Show an example ?

 

[littlepete]

hello

excel click on first cell to find cell in other column with same value​

read my post there to understand what one of the problems is... thank you !!!