Help please: I selected "go to-special-visible cells only", but the problem
is the selection does not stay. This is what I mean:
1. I selected the entire worksheet with the filter on, only 200 out of 800
records are visible;
2. I select "go to-special-visible cells only"

And then I do it again just to make sure the selection is there, however, I
find that after I "go do-special", the tab still shows "comments" being
selected, NOT "visible cells only". Does this sound right to you?

When I copy and paste, sometimes the visible ones are copied, but most
times, I will get message saying Excel does not have enough resources to
complete this task, when I'm only copying 8 rows of data.

Do you know what problem I'm experiencing?
Thanks much!
Sunny