mahaveer
Member
seLECT SHEET 1
Select K1:N100
Press Ctrl+F
Click on Option>Select Values from Look in Combo>Find All>Press Ctrl+A
Close Find and Replace Dialog box
Now press Delete key
BECAUSE I HAVE SOME CELLS FROM COLUMN K1 TO COLUMN N100 WHICH HAVE INCLUDE IF FORMULA BUT THEIR RESULTS IS "" (BLANK)..... SO I WANT TO DELETE THEM......THROUGH VBA ONLY..
THEREFORE I NEED A VBA CODE FOR THE ABOVE 6 LINES ONLY?
Select K1:N100
Press Ctrl+F
Click on Option>Select Values from Look in Combo>Find All>Press Ctrl+A
Close Find and Replace Dialog box
Now press Delete key
BECAUSE I HAVE SOME CELLS FROM COLUMN K1 TO COLUMN N100 WHICH HAVE INCLUDE IF FORMULA BUT THEIR RESULTS IS "" (BLANK)..... SO I WANT TO DELETE THEM......THROUGH VBA ONLY..
THEREFORE I NEED A VBA CODE FOR THE ABOVE 6 LINES ONLY?