ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I delete a row (https://www.excelbanter.com/excel-worksheet-functions/133641-how-do-i-delete-row.html)

jcallahan

How do I delete a row
 
Hi want to say if B2=B3, delete row 2... any clues?

Fred Smith

How do I delete a row
 
You'll need a macro to do this. How complicated it gets depends on how automatic
you want the deletion. If you are happy to check manually (by, say, clicking a
button), it's a pretty simple macro. If you want it to check with every recalc,
you'll need an event macro.

Post to the .programming group if you need more help.

--
Regards,
Fred


"jcallahan" wrote in message
...
Hi want to say if B2=B3, delete row 2... any clues?





All times are GMT +1. The time now is 01:47 AM.

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