To check if a table exists?

[Lil2606]

Hi all, is there a simple code to check if a table exists in my document already?

I am setting up a log, and every time someone opens my workbook, the username (its on a shared drive) and the date gets logged, and each macro (if they run it) logs a time, now the "If they run it" is my problem..

For example on Sheet2, the user just copies raw data into the specified cell, and then the macro removes duplicate reports and unnecessary columns and such and converts the raw data into a table. If they then save it, the next person who logs in doesn't need to run this macro again, and the time log doesn't happen, as the table is already there.. so if the table already exists on Sheet2, I would like to input "Pre-exising" into the cell on Sheet1 but how do I do this?

Cheers

 

[RoryA]

If you just want to check if there is a table on sheet2, you can use:

If sheets("Sheet2").Listobjects.Count <> 0 then

 

[Lil2606]

oh how true.. thanks! :D