hiko-blog https://blog.hatena.ne.jp/hiko-blog/ Hiko.Blog Excel VBA活用術 https://hiko-blog.hatenadiary.com/ VBA Sub HighlightLastNonEmptyCell() Dim rng As Range Dim cell As Range Dim lastNonEmptyCell As Range Dim inputRange As Range ' ユーザーにセル範囲を指定させるための InputBox を表示 On Error Resume Next Set inputRange = Application.InputBox("セル範囲を指定してください。例：A1:E10", "セル範囲選択", Type:=8) On Error GoTo 0 If inputRange Is Nothing … 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhiko-blog.hatenadiary.com%2Fentry%2F2024%2F03%2F04%2F213624" title="HighlightLastNonEmptyCell - Hiko.Blog Excel VBA活用術" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2024-03-04 21:36:24 rich https://hiko-blog.hatenadiary.com/entry/2024/03/04/213624 1.0 100%