View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gert-Jan[_2_] Gert-Jan[_2_] is offline
external usenet poster
 
Posts: 29
Default Macro to delete specific rows

Hi,

In sheet1, range A1:P40 I have values. In the range A1:A40 there are ID
numbers. In sheet2, range (A1:A10) there are also ID numbers, wich might
correspondend to the range A1:A40 in Sheet1. I want a macro that deletes the
rows in sheet1 with the ID-numbers that are in sheet2.

Any help would be appriciated.

Beste regards, Gert-Jan