2022-09-01から1ヶ月間の記事一覧

excel - vba loop

www.exceldemy.com

vba - WorksheetFunction.CountIf

Dim okCount As Integer Dim ngCount As Integer Dim emptyCount As Integer okCount = WorksheetFunction.CountIf(Range("D9").CurrentRegion.Columns(2), "ok") ngCount = WorksheetFunction.CountIf(Range("D9").CurrentRegion.Columns(2), "ng") emptyCo…

excel - vba,vscode

kanegolabo.com webbibouroku.com

excel - 相対参照と絶対参照を切り替え

dekiru.net

powershell - スコープ

tech.blog.aerie.jp