Avatar of Kevin Willyerd
Kevin Willyerd
Flag for United States of America

asked on 

excel Delete row if certain cell in row is blank

I have a worksheet that I cut and paste from an html table. As pasted in it has extra rows that need to be deleted. If the cell in column B is blank the row needs to be deleted. In row 2 there are several controls that need to be deleted with that row when it is deleted. The number of rows will vary from week to week. I can write most of the for loop to step thru the table but am unsure how to check to see if the current cell is blank. Also dont know how to delete the controls in row 2. Can someone point me in the right direction?
Microsoft ExcelVB ScriptSpreadsheets

Avatar of undefined
Last Comment

8/22/2022 - Mon