How do I create a macro that will automatically input lines?
I am trying to create a macro that will delete lines based on a number that
is inputted in a particular cell. For instance if the number is cell A1 is 10 then input 10 rows for data. |
How do I create a macro that will automatically input lines?
Rows(10).Resize(Range("A1").Value).Delete -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "cporter" wrote in message ... I am trying to create a macro that will delete lines based on a number that is inputted in a particular cell. For instance if the number is cell A1 is 10 then input 10 rows for data. |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com