marcus-e
1/26/2018 - 5:54 PM

Miscellaneous VBA Notes

Helpful hints/tips/tricks for working with VBA in Excel.

MiscVBANotes.md
content_copyfile_download
  • Rendered
  • Source

Miscellaneous VBA Notes

Remove row where there is a duplicate value on specified column. Range is the length of the row to delete. Header is whether or not the table has headers.

ActiveSheet.Range("A:H").RemoveDuplicates Columns:=1, Header:=xlYes