VBA

背景
投稿者投稿者cum  いいね3  お気に入り登録
プレイ回数450  難易度(3.5) 90秒 英語 英字
タグプログラミング

関連タイピング

関連タイピング一覧

問題文

ふりがな非表示 ふりがな表示

(dim fpath as variant)

dim fpath as variant

(numwide=strconv(i,vbwide))

numwide=strconv(i,vbwide)

(msgbox format(a,"yyyy/mm"))

msgbox format(a,"yyyy/mm")

(set wb=activeworkbook)

set wb=activeworkbook

(for i=1 to sheets.count)

for i=1 to sheets.count

(cells(rows.count,"a").end(xlup).row)

cells(rows.count,"a").end(xlup).row

(for each ws in wb.worksheets)

for each ws in wb.worksheets

(rows("1:1").wraptext=true)

rows("1:1").wraptext=true

(activewindow.freezepanes=true)

activewindow.freezepanes=true

(activesheet.copy)

activesheet.copy

(sheets(1).copy after:=sheets(1))

sheets(1).copy after:=sheets(1)

(if activesheet.autofiltermode=true)

if activesheet.autofiltermode=true

(for each i in thisworkbook.sheets)

for each i in thisworkbook.sheets

(debug.print i.name)

debug.print i.name

(selection.value=selection.value)

selection.value=selection.value

(byval target as range)

byval target as range

(call userform1)

call userform1

(application.displayalerts=false)

application.displayalerts=false

(application.cutcopymode=false)

application.cutcopymode=false

(activeworkbook.close)

activeworkbook.close

など

(if typename(selection)<>"range")

if typename(selection)<>"range"

(application.dialogs(xldialogsaveas).show)

application.dialogs(xldialogsaveas).show

(range("b2").autofilter 2, "<>")

range("b2").autofilter 2, "<>"

(createobject("scripting.filesystemobject"))

createobject("scripting.filesystemobject")

(activeworkbook.saveas path)

activeworkbook.saveas path

("=datedif(rc[-2],rc[-1],""y"")")

"=datedif(rc[-2],rc[-1],""y"")"

(range("c3:d8").select)

range("c3:d8").select

(specialcells(xlcelltypeconstants,23))

specialcells(xlcelltypeconstants,23)

(workbooks.add)

workbooks.add

(activesheet.printpreview)

activesheet.printpreview

(fittopageswide)

fittopageswide

(fittopagestall)

fittopagestall

(numberformatlocal)

numberformatlocal

問題文を全て表示 一部のみ表示 誤字・脱字等の報告

cumのタイピング

オススメの新着タイピング

もっと見る
タイピング練習講座 ローマ字入力表 アプリケーションの使い方 よくある質問

人気ランキング

もっと見る

注目キーワード