ExcelBanter - Paste to Visible Cells only

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Paste to Visible Cells only (https://www.excelbanter.com/excel-discussion-misc-queries/191947-paste-visible-cells-only.html)

Sandy Burgess

Paste to Visible Cells only

Is there anyway to paste to visible cells only?

I know you can use EditGo toSpecialVisible Cells only to copy visible
cells but I need to paste to only the visible cells.
--
Sandy Burgess

Dave Peterson

Paste to Visible Cells only

I try to sort the data to make the visible cells contiguous.

Sandy Burgess wrote:

Is there anyway to paste to visible cells only?

I know you can use EditGo toSpecialVisible Cells only to copy visible
cells but I need to paste to only the visible cells.
--
Sandy Burgess

--

Dave Peterson

All times are GMT +1. The time now is 03:10 PM.