<div>
You could use SpecialCells(xlCellTypeVis<wbr />ible) to return only the visible cells in the range you want to copy to.<br />
<br />
For example, copy D1 to visible cells in B2:B100.<br />
<br />

<pre><code id="code-20-39630678-1">Range(&quot;D1&quot;).Copy Range(&quot;B2:B100&quot;).SpecialCells(xlCellTypeVisible)</code></pre>
</div>


You could use SpecialCells(xlCellTypeVisible) to return only the visible cells in the range you want to copy to.

For example, copy D1 to visible cells in B2:B100.



Range("D1").Copy Range("B2:B100").SpecialCells(xlCellTypeVisible)

<div>
Here is the microsoft write-up for what you are asking. The &quot;Go To Special...&quot; function is what you are looking for.<br />
<br />
There is also a keyboard shortcut for this but it seems to be slipping my mind today.<br />
<br />
<a href="http://office.microsoft.com/en-us/excel-help/copy-visible-cells-only-HA010244897.aspx" rel="ugc">http://office.microsoft.com/en-us/excel-help/copy-visible-cells-only-HA010244897.aspx</a>
</div>


Here is the microsoft write-up for what you are asking. The "Go To Special..." function is what you are looking for.

There is also a keyboard shortcut for this but it seems to be slipping my mind today.

http://office.microsoft.com/en-us/excel-help/copy-visible-cells-only-HA010244897.aspx [http://office.microsoft.com/en-us/excel-help/copy-visible-cells-only-HA010244897.aspx]

<div>
<div class="content wysiwyg-content">
Hi Guys, in Excel if I want to copy a cell and paste the contents from the Cell down other cells in a Auto-Filtered Column. How do I do it without pasting over the Hidden rows?
</div>
</div>


Hi Guys, in Excel if I want to copy a cell and paste the contents from the Cell down other cells in a Auto-Filtered Column. How do I do it without pasting over the Hidden rows?

How to Copy and Paste Visible Cells only

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