Peskarik
02-01-2008, 07:26 AM
This is only partly a VBA question.
Assume:
on one sheet you have two columns, like this:
1 10
2 0
3 20
4 0
5 30
Now I mark the row above the two columns and use Filter button to filter away those observations that contain 0 in second column. Now I want to copy the remaining 3x2 array and paste it somewhere else.
When I do this copypaste, I get back the initial 5x2 array! :banghead:
What should I do to get only the 3x2 array.
I have Office 2007. In Office 2003 it works. :think: :help
Assume:
on one sheet you have two columns, like this:
1 10
2 0
3 20
4 0
5 30
Now I mark the row above the two columns and use Filter button to filter away those observations that contain 0 in second column. Now I want to copy the remaining 3x2 array and paste it somewhere else.
When I do this copypaste, I get back the initial 5x2 array! :banghead:
What should I do to get only the 3x2 array.
I have Office 2007. In Office 2003 it works. :think: :help