Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info)
 

like you said, somehow excel seems to be remembering the
xlveryhidden. or maybe it has something to do with using 2 sessions
of excel..............
why don't you try searching the newsgroup - maybe somebody else has
had a similar problem & found a solution??? sorry, i don't have one.
:)
susan


On Jan 31, 10:06*am, wrote:
On 31 Jan, 14:11, Susan wrote:

can you try a simple work around - add

unhide sheet

do you thing

hide sheet

then it won't copy the hidden attribute, since it won't BE hidden @
the time.
just a simple idea.
:)
susan

Hi Susan, thanks for your comment. I tried and things become even more
esoteric.
I tried the same test, but instead of calling sheet1.range("A1").copy
I'm doing:

sheet1.visible = xlSheetVisible
sheet1.Range("A1").Copy
sheet1.Visible = xlSheetVeryHidden

And the problem is still the same. Puzzled, I simplified the test and:
1. Type a number in the (visible) Sheet1!A1
2. Go to VBA and type:
sheet1.Range("A1").Copy
sheet1.Visible = xlSheetVeryHidden
3. Paste into the second session of Excel

And the spreadsheet I copied the data to becomes invisible! So it
isn't that the spreadsheet i copy from is hidden, but Excel seem to
remember that I made the sheet invisible after the copy operation, and
for arcane reasons it signals it to the other session of Excel...

Am i going nuts?
thanks
gc