Copy range from one sheet to another until first blank row

[ISmellGas]

Hi,

I have a range of cells I want to copy from one sheet to another but only until the first row (within that range) of blank data.

Cells C6 to F6 contain the first row of data and this will increase with additional rows over time. There will be more data in other columns so rather than checking the first blank row on the sheet it has to be within the four columns C to F.

Hope that makes sense.

Can anyone help?

[Kamboj]

this code will help you to find first cell with value within range

Please Login or Register  to view this content.

[ISmellGas]

this code will help you to find first cell with value within range

Please Login or Register  to view this content.

Thanks but that's not really what I'm looking for.