View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Newbie1[_3_] Newbie1[_3_] is offline
external usenet poster
 
Posts: 3
Default Somebody hit me with a bigger hammer... I forgot how to..

A while back, I requested some info and somebody was nice enough to provide
that for me.

What I want to do is to set a filter, and then fill a column, ensuring that
it ONLY fills the records that are showing (visible)!
I have tried this once or twice and it effected all of the records,
including hidden.

I believe the same command will prevent only visible records to be cut and
pasted, but I am not sure, if not, what is the command that will only allow
the visible records to be cut and pasted.


Thanks
Bruce