Skip to content

XL n CAD

Excel isn’t just a tool – it's a way of Life!

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Resources

Macro to remove Data Validation


Remove Data Validation from the cell D10


Sub RemoveDVfromACell()
Range("D10").Validation.Delete
End Sub

Remove Data Validation from the entire worksheet


Sub RemoveDVfromASheet()
Cells.Validation.Delete
End Sub

How to use codes shared here?

Recent Posts

  • Python Program to Read Excel Files
  • VLOOKUP from Two or more Tables
  • TEXTSPLIT and 13 New Functions in Excel

Archives

  • March 2023
  • May 2022
  • April 2022
  • March 2022
  • November 2021
  • May 2021
  • April 2021
  • February 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • April 2019

Fly to

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Resources

Top 25 MS Word Tips & Tricks

https://youtu.be/l25Evu4ohKg

Course on Scripting in AutoCAD

Excel Bible

Recent Posts

  • Python Program to Read Excel Files
  • VLOOKUP from Two or more Tables
  • TEXTSPLIT and 13 New Functions in Excel
  • How to find the Most Repeated Text or Number in Excel
  • How to create a Gantt Chart in Excel

Categories

  • Advanced Excel (2)
  • AutoCAD (3)
  • Conditional Formatting (2)
  • Data Validation (2)
  • Excel Charts (3)
  • Excel Errors (1)
  • Excel Formula (28)
  • Excel Functions (14)
  • Excel Macro (4)
  • Excel Shortcuts (2)
  • Excel Table (2)
  • Excel Tips and Tricks (41)
  • Excel Tutorial (3)
  • Google Maps (1)
  • GoogleSheets (1)
  • MS Excel (83)
  • MS Word (4)
  • Pivot Table (4)
  • Power Query (30)
  • PowerPoint (1)
  • Python (1)
  • Uncategorized (3)

© 2023 XL n CAD | WordPress Theme: Attesa by AttesaWP.com

Categories

  • Advanced Excel
  • AutoCAD
  • Conditional Formatting
  • Data Validation
  • Excel Charts
  • Excel Errors
  • Excel Formula
  • Excel Functions
  • Excel Macro
  • Excel Shortcuts
  • Excel Table
  • Excel Tips and Tricks
  • Excel Tutorial
  • Google Maps
  • GoogleSheets
  • MS Excel
  • MS Word
  • Pivot Table
  • Power Query
  • PowerPoint
  • Python
  • Uncategorized