Type Mismatch when switching from single cell Range value to multiple cell range value

Fixed, apologies.

This copies the first row in all rows down to iRow. Upon looping to a row with data entered, it should not replace existing data. Thoughts?

I created a work around by adding three separate loops for each column, but I figured there should be a way to execute this with less code. See below:

Please Login or Register  to view this content.

Given: B:D column of first row in loop (row 6 in last code snippet) will always have contain data (Xb,Xc,Xd in example file).

Run Loop, Repeat to last row: If current cell range ("B"Row:"D"row) has no content, then copy contents of row-1 (the above row) and paste into current range ("B"Row:"D"row). If cell range contains data, do nothing. Loop to next row.

Per attached file: code will identify that row 6 is populated, do nothing, and move to row 7. Row 7 being empty, will have row 6 copy/pasted into row 7. Row 8 being empty will have row 7 copy/pasted into row 8, etc., until row 10 where the code will again, do nothing. Row 11 being empty,will have row 10 copy/pasted into row 11, etc.

My original code accomplished only one column: (Col B)

Please Login or Register  to view this content.

I tried to add Col B:D by rewriting the following:

Please Login or Register  to view this content.

This gives me a type mismatch error. I wanted to understand why & to clean up code.
Example file attached, without macros.

BeforeAfter.xlsx

Thanks, thats works wonderfully and I will marked [Solved], but can you elaborate on why I got the type mismatch error. Just trying to improve my understanding and not just ask for a solution. Thanks again!!