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?
Only by not copying it in the first place, or deleting it afterwards.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Bob,
Besides not selecting the column what about using SpecialCells XlVisible?
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
I didn't say not selecting Doug, I said not copying. Copying visble cells only achieves just that.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
