thats Great!! Thanks..exactly what i wanted!!

"bj" wrote:

depending on what you are doing
select the range in whch you are interested
edit-goto-special-visible cells
select OK
copy

"swati" wrote:

I think that there is a way to copy and then paste "visible" cells while
using subtotals. Am i right? And if i am, where can i get that option from?