シリアル値になってるので、文字列に変換してやる必要がある
time = TimeValue(Format(Cell(1,1).Value, "h:mm:ss"))
More than 5 years have passed since last update.
セルの値をマクロで Timevalue と変換した時にエラーが出る
Last updated at Posted at 2012-12-26
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