ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Removing all data from two columns (https://www.excelbanter.com/excel-programming/379801-removing-all-data-two-columns.html)

Michael Koerner

Removing all data from two columns
 
I would like to be able to remove all the data in columns B & C starting in
B2 and C2 before new data is inserted.

--

Regards
Michael Koerner




Michael Koerner

Removing all data from two columns
 
You make it sound so easy. Thank you very much and have a great holiday
season

--

Regards
Michael Koerner


"Gary''s Student" wrote in message
...
Sub clrit()
Range("B2:C65536").Clear
End Sub



--
Gary's Student


"Michael Koerner" wrote:

I would like to be able to remove all the data in columns B & C starting
in
B2 and C2 before new data is inserted.

--

Regards
Michael Koerner








All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com