greedquest/listobject-withevents

Create a list-object events listener package

listobject-withevents's Issues

Fix linefeed character

Repo uses LF not CRLF meaning .bas .cls files cannot be imported by VBE or RD. Need to use .gitattributes file to fix treatment.

Workaround execute the following two in powershell in the src directory of this repo to fix the newlines:

function Normalise{
param($file)
((Get-Content $file) -join "`r`n")  | Set-Content $file
}

And in the src directory

Get-ChildItem -File | ForEach-Object {Normalise $_.fullname}

Basic Features

Essentials:

• Insert/append row
• insert/append col
• change column name
• data value change
• Append multiple cols
• insert/append multiple rows
• Resize
• Move table
• select new table area (resize and move)

Advanced:

• delete
• move sheet
• move rows/cols within table
• Power Query refresh (resized+data changed)
• Filter
• Sort