Run-time Error Multiple Selections SpecialCells xlCellTypeBlanks

Hi all,

Using Excel 2007

I'm trying to create a range object using SpecialCells(xlCellTypeBlanks) so I can then add a VLookup formula to each blank.

Excel is returning this error

Run-time error '1004':
The command you chose cannot be performed with multiple selections.
Select a single range and click the command again.

Is there a better way other than looping through each cell individually?
Will my Lookup formula update properly?
The formula below shows Row 2 but it should update based on the row it is pasted to.

thx
w

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Maybe change this, too:

Please Login or Register  to view this content.