May be you can try adding 'auto-filter' to your data and try copying pasting.
Despite that I can print a sheet includes hidden rows or columns , as I can leave out those hidden columns or raws, but I can not copy from the same sheet these apparent rows and columns only , regardless those hidden columns and rows !!
As the result (which I do not want) I've to paste all the hidden and apparentcolumns and rowsto gother.!!
Last edited by lion; February 21st, 2006 at 05:56.
Thank you Meg
But in this case I do'nt think that I can solve this matter, especially that I have thousands of hidden rows !
if only I have a choise to select the only apparent rows.!
thank you again ..
Dim rngCopy As Range
With Worksheets("Copy from")
Set rngCopy = .Range("A1:F" & .Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
With Worksheets("paste to")
To do this manually, select the range to copy (including hidden rows) and push F5 then click Special and check Visible cells only - Ok. Now copy/paste
There are currently 1 users browsing this thread. (0 members and 1 guests)