Check if a Table is empty using VB

Hi guys, not sure if this has been posted before but i couldn't find anything to answer my questions.

I have a table in excel range B5:M32 with the top two rows containing merged cells (B5:M6). I need to write a macro to copy data from cells B38:C38 into the above table.

I need the macro to first check to see if there is any data already entered i.e. check if the table is empty. If it is empty then paste the cells in the first cell (B7). If the table already has data entered i need to move to the last entry then move down one cell and paste the copied cells.

I have figures out the copying/pasting functions but am struggling with the part to check if the table is empty and moving down the table without using cell references.

Any help would be much appreciated.

Martin

Originally Posted by mrice

Try this

Please Login or Register  to view this content.

Hi

Thanks to both the posts, i've used mrice's suggestions and this seems to work perfectly and easier to understand for a novice like myself.

Much appreciated for both your comments.

Martin