View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default ActiveCell.Row noncontiguous

I am using the ActiveCell.Row to copy and paste cell content.

Range("K" & ActiveCell.Row & ":" & "M" & ActiveCell.Row).Copy

It allows the user to perform certain functions without being concerned
about which columns to select.
Many times they will be selecting multiple rows. Is there a modification to
this routine that allows for the
selection of multiple or noncontiguous rows?

Thanks,
Steve