• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    You think you are the best at working with dates?

    Hi, you can use =EDATE(A1,12) in cell B2 if your date format is dd-mmm-yy in A1. Thanks, Suresh Kumar S
  2. S

    how to delete a cell?

    Hi, Can you please try the below code Sub delblankcell() On Error GoTo test1 Selection.SpecialCells(xlCellTypeFormulas, 2).Select Selection.ClearContents Range("a1").Select test1: MsgBox "There is not blank cell" End Sub Thanks, Suresh Kumar S
  3. S

    how to delete a cell?

    Hi, Can you please create a new module and paste the below code and run (it will delete the entire row) Sub delblankcell() On Error GoTo test1 Selection.SpecialCells(xlCellTypeFormulas, 2).Select Selection.EntireRow.Delete Range("a1").Select test1: MsgBox "There is not blank cell" End...
  4. S

    how to delete a cell?

    Hi, Press F5 and select special then slect formulas then uncheck numbers,logicals and errors. Thanks, Suresh Kumar S
View older results
Back
Top