[ 初めての方へ | 一覧(最新更新順) | 全文検索 | 過去ログ ]
『VBAでSUMIF』(はじめの一歩)
SUB TOTAL()
DIM RNO AS RANGE DIM HANI AS RANGE DIM CNO AS RANGE DIM GOKEI AS RANGE DIM TOTAL AS DOUBLE SET RNO=RANGE("C65536"),END(XLUP) SET HANI=RANGE(C1:RNO") SET CNO=RANGE("N65536").END(XLUP) SET GOUKEI=RANGE("N1:CNO") TOTAL=APPLICATION.WORKSHEETFUNCTION.SUMIF(HANI,"計",GOKEI) END SUB
コレは、ユーザー定義関数を作ったのかしら? それとも??? こんな感じでいかがでしょ? Sub TOTAL() Dim RNO As Long Dim HANI As Range, GOKEI As Range RNO = Range("N" & Rows.Count).End(xlUp).Row Set HANI = Range("C1:C" & RNO) Set GOKEI = Range("N1:N" & RNO) Selection = Application.WorksheetFunction.SumIf(HANI, "計", GOKEI) End Sub (キリキ)(〃⌒o⌒)b
[ 一覧(最新更新順) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.