I'm new to VBA and can't figure this out. I need excel to look at cell A2 and delete rows 3-50 if cell A2 is blank. Can someone help me out with a code for this? Also, is there a way that excel can do this automatically, without having to run a macro. For example if I delete cell A2, it automatically deletes rows 3-50?
Any info is appreciated! TIA
Any info is appreciated! TIA