PDA

View Full Version : I don?t want the hide cell to be copying!! How to do it?



jiura
09-22-2007, 11:33 AM
Hello!
I have excel Sheet. And Some rows or columns are hide ( trey width or height =0).
For Example Column B is hide.
But when I copy columns range (for example from column A to C) column B copying too!!! But I don?t want this cell to be copy! This cell is hide from user! How can I do such thing?

Bob Phillips
09-22-2007, 11:49 AM
Only by not copying it in the first place, or deleting it afterwards.

YellowLabPro
09-22-2007, 12:02 PM
Bob,
Besides not selecting the column what about using SpecialCells XlVisible?

Bob Phillips
09-22-2007, 01:11 PM
I didn't say not selecting Doug, I said not copying. Copying visble cells only achieves just that.