paste visible cells not working!!!!

Select the range of cells that are visible. Click on Find & Select, click on Go To Special. Click on Visible Cells Only and click OK. Immediately click on Copy. Select a cell where you want the values that is outside the range of hidden cells. That means do not paste into a range that has hidden rows or columns. Click Paste and the visible cells should be pasted where you want.

If you paste into an area with hidden rows or columns, you can get some very strange looking results.

Select the range of cells that are visible. Click on Find & Select, click on Go To Special. Click on Visible Cells Only and click OK. Immediately click on Copy. Select a cell where you want the values that is outside the range of hidden cells. That means do not paste into a range that has hidden rows or columns. Click Paste and the visible cells should be pasted where you want.

To paste into cells that are hidden, type the cell address that would be the upper left of the range that you want to paste into the NAME BOX (left of the formula bar and above the row numbers) hit enter then Paste. The pasting will be done in cells that you cannot see. If the pasted range is greater than the range of cells hidden, some values will become visible....depends upon what you have hidden. I have tried this and it does work.