• 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.

I want delete particular condition through VBA in excel

S

sivaprakasam

Member
Hi i am trying to be delete below this condition in all sheet in a workbook through VBA in excel (Excel Version 2013)

I have more than 40 sheet in workbook below condition, but i cannot do individual wise.

Kindly help VBA

  • "A Column" is to be delete
  • "Row 5" is to be delete
  • Yellow Color Cell is to be Delete with all clear
  • Red Color Cell is to be Delete the Content only (Text or Number, or formula, symbol), but return only empty cell with format
  • “E10” Cell is to be Delete content with format
  • “E11” Cell is to be Delete content without format
 

Attachments

  • Bookss.xlsx
    10.4 KB · Views: 1
sivaprakasam
Before more steps
... do You really mean to delete something?
> after 'A-column' has deleted then ALL other columns will move like one column to left
> after 'Row 5' has deleted then ALL rows below will move like one row upward
> other four Your steps could do something same kind of effect with possible new cell references
 
You must log in or register to reply here.
Back
Top