automated copy in table

[LiamF]

Hello, I have a macro where at one point I need to copy the same value in one column of a table. This is to be used on a number of tables but they will vary in how many rows they have.

I'm using the code;

Please Login or Register  to view this content.

This works fine for all tables except ones that only have one row ie. in some cases the value in C5 does not need to be copied down as there are no more rows in the table. At the moment the macro will copy the value in C5 to all the cells in column C to the bottom of the Worksheet.

is there any way to avoid this?

many thanks
Liam

[VBA Noob]

LiamF,

Please wrap your code next time.

Maybe

Please Login or Register  to view this content.

VBA Noob

[LiamF]

hi, thanks. This seems to work in tables that only have one row but not in those with more than one row. ie. it's not copying the value in C5 down.

[VBA Noob]

Sorry


Try

Please Login or Register  to view this content.

[LiamF]

works great. many thanks.