View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Kraemer Paul Kraemer is offline
external usenet poster
 
Posts: 34
Default Clear all rows except first two

Hi,

I am using Excel 2007. I want to write a VBA Subroutine to delete/clear all
data on a particular worksheet except for the first two rows.

This worksheet can have any number of rows filled with data. Can anyone
give me a hint on how I can select and clear all rows containing data except
for the first two rows?

Thanks in advance,
Paul
--
Paul Kraemer