<div>
Steve<br />
<br />
Any particular value(s) you want to replace the blanks with?
</div>


Steve

Any particular value(s) you want to replace the blanks with?

<div>
Apply autofilter, and filter on blanks for the column.<br />
Type the value in the first cell, and copy to the others.<br />
Then remove the filter.
</div>


Apply autofilter, and filter on blanks for the column.
Type the value in the first cell, and copy to the others.
Then remove the filter.

<div>
This worked perfectly! &nbsp;Thank you Experts for your comments and solutions.
</div>


This worked perfectly!  Thank you Experts for your comments and solutions.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
I have an excel spread sheet that has blank valuesr. &nbsp;This column also has other values in it that I do not want over written. &nbsp;I would like to put a value into all of the blank fields of this column. &nbsp;Can someone assist? &nbsp;Thanks in advance.<br />
<br />
Sub
</div>
</div>


Hello Experts,
I have an excel spread sheet that has blank valuesr.  This column also has other values in it that I do not want over written.  I would like to put a value into all of the blank fields of this column.  Can someone assist?  Thanks in advance.

Sub

Excel Problem

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.