1

More than 5 years have passed since last update.

@EastAzy(East Azy)in

運営者ギルド

VBAでTitleの列番号を入手する関数を作成する

VBA

Posted at 2018-05-26

仕事でVBAを操作する機会がたくさんあったのでメモ。

Function Title(WS as Worksheet, TitleName as string)

set WS = WS
Dim TitleRow

TitleRow = 1 'titleの列
For i = 1 to Cells(TitleRow, Columns.Count).End(xlToLeft).Column

if TitleName = cells(TitleRow, i)
exit for
end if

Title = i

end

1

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

1