�V�[�g��֘A�̃e�N�j�b�N�b��e�N�j�b�N

Excel VBA�F�V�[�g��֘A�̃e�N�j�b�N

��e�N�j�b�N�ł́A��e�N�j�b�N�̒ǉ��E��s��Ă��܂��B
�X�V�R��e��c�́A��e�N�j�b�N�g�b�v�y�[�W�ł��m�F��B�@�� e�N�j�b�N �g�b�v�y�[�W

�V�[�g��֘A�̃e�N�j�b�N �ڍ�
�A�N�e�B�u�V�[�g�ȊO�̂��ׂẴV�[�g�𖳏��ɍ폜��
�R��{�{�b�N�X�ɃA�N�e�B�u�V�[�g�̖��O��\��
�V�[�g��בւ��
��V�[�g�̑I��i��False��w�肷��j
��V�[�g�̑I��i�z��g�p��j
�V�[�g�̍Čv�Z��ݒ肷��(EnableCalculation�v��p�e�B)
��̃V�[�g�̃f�[�^��1�̃V�[�g�ɃR�s�[��
�V�[�g�ی�̃p�X��[�h�ɓ��͂ł��Ȃ��ݒ肷��
�X�N��[��ł��͈͂��w�肷��iScrollArea�v��p�e�B�j
�ׂ̃V�[�g��\��v��p�e�B
�I��ꂽ�V�[�g�𑀍삷��
��[�N�V�[�g��ǉ��āA��[�N�V�[�g�ɖ��O��t��
Array�֐��FillAcrossSheets��\�b�h��g��āA��V�[�g�ɒl�𓯎��ɓ��͂��
��̃��[�N�V�[�g��V�K�̃u�b�N�ɃR�s�[��
��[�N�V�[�g�̕ی��ݒ�E��
�S�ẴV�[�g��w�肳�ꂽ��iCountIf�֐��j
�V�[�g�P��B��̐��V�[�g2�ɓ]�L��Ĉ��
��X�g�{�b�N�X�̃f�[�^��V�[�g�ɓ]�L��
��u�b�N��̃V�[�g��R�s�[��V�[�g��ǉ��
�I��Ă�V�[�g��
��[�N�V�[�g�̃R�[�h��擾��iCodeName�v��p�e�B�j
�I��Ă��镡��V�[�g�̓��e��V�K�ɒǉ��V�[�g�ɓ��͂��
�V�[�g�̃C��f�b�N�X�ԍ��擾��iIndex�v��p�e�B�j
�V�[�g1�ƃV�[�g2��ׂĕ\��
�V�[�g��̎擾�i�Z��Ɣz��Ɋi�[�j
�G�N�Z��父��V�[�g�ւ̈��
��[�N�V�[�g�ɔz�u��{�^��g�p��̋Z�@�ɂ��
�A�N�e�B�u�ɂ��V�[�g��X�g�{�b�N�X�Ŏw�肷��
��̕��܂܂�Ă��V�[�g��t��ꂽ�V�[�g��ׂđI��Ԃɂ��
�V��V�[�g�𒼌�ɑ}��A�l�Ɛړ��݂̂��R�s�[��
�O�̃V�[�g�⎟�̃V�[�g��I�� iNext�v��p�e�B / Previous�v��p�e�B�j
�V�[�g��w�肵�ău�b�N��ǉ��
�V�[�g��̃R��g��[��̒l�N��A
�V�[�g��̃t�H�[��R��g��[��̒l�N��A
��̕��܂ރV�[�g�̑��݂𔻕ʂ��
�V�[�g�ɔz�u��e�L�X�g�{�b�N�X�̒l��x�ɃN��A��
��̖��O�̃V�[�g�𖳏��ɍ폜��
��[�N�V�[�g��Q�Ƃ��(Worksheets�v��p�e�B)
�V�[�g��I��(Select��\�b�h)
�V�[�g��A�N�e�B�u�ɂ��(Activate��\�b�h)
�A�N�e�B�u�V�[�g��Q�Ƃ��(ActiveSheet�v��p�e�B)
�V�[�g��𐔂��(Count�v��p�e�B)