View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Derwood Derwood is offline
external usenet poster
 
Posts: 5
Default drag data vertically over hidden cells.. ignore hidden cells

hi
when copying and pasting data vertically on a filtered sheet the data
is pasted on the rows that are hidden in between . how can i have it
ignore the hidden cells and only paste to the visible cells
thanks