Code to fill in blanks isn't working

**thedon_1** · 04-27-2012, 06:37 AM

I use this code to fill in blanks in one of my workbooks.

Please Login or Register  to view this content.

It selectes data in one column based on the amount of rows in another and then just fills in the blank cells based on what's above.

Unfortunately, it's not working in another sheet.

I get a complie error: Expected function or variable and Selection on the 4th line is highlighted.

Any ideas?

Thanks

**dilipandey** · 04-27-2012, 07:30 AM

Hi thedon_1,

By 4th line do you mean :-
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "=R[-1]C"

check if that sheet has blank cells (even not formulas which are resulting in blanks).. ?

Regards,
DILIPandey

<click on below 'star' if this helps>