Looping through row

Hi,

I am trying to figure out how to do the following via VBA and unable to find any answers so far.

Have True of false values in Row 1.

Want to loop through this row. For every true value found within the row it will copy the column of the cell and paste values.

Thanks
Dan

Please Login or Register  to view this content.

Thanks Bishonen.

It seems to just debug with 1004 run time error, highlighting the cell.pastespecial line. I have tried amending to selection.pastevalue etc and still no joy.