Deleting a row
Could someone please give a code exaple
to delete a row in Sheet1 by row number. Whether it's empty or not and close up the gap. Thanks - Kirk |
Deleting a row
Worksheets("Sheet1").Rows(97).Delete
-- __________________________________ HTH Bob <kirkm wrote in message ... Could someone please give a code exaple to delete a row in Sheet1 by row number. Whether it's empty or not and close up the gap. Thanks - Kirk |
Deleting a row
On Tue, 10 Mar 2009 09:16:03 -0000, "Bob Phillips"
wrote: Worksheets("Sheet1").Rows(97).Delete Thank you Bob, worked a treat. Cheers - Kirk |
All times are GMT +1. The time now is 11:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com