I need a formula that would insert a blank row above the row that contains a
specific value. ie, if a cell contains "x", insert a blank row above it.

Or, the same in a macro.

Thanks,

chris