·¢¸öÌû×Ó¸Ð̾һÏ°ïÈË×öexcel´¦ÀíÊý¾Ý£¬µ«ÊǹýÓÚ·±Ëö£¬ËùÒÔ·±Ôò˼±ä¡£¡£¡£
дmarco¡£ÔÀ´ÒÔΪ¾ÍÊÇVB£¬½á¹û·¢ÏÖÁËVBAÕâ¸ö×Ó¼¯
È»ºó±ä×ö±ß²é×ÊÁÏ£¬Á½¸ö¶àСʱ°ÑÖ÷Òª²¿·Öд³öÀ´ÁË¡£ £¡££
½ÓמÍÊÇÍ´¿àµÄdebug¡£
Æäʵһ¸öºÜ¼òµ¥µÄ¶«Î÷
ÓÃMarco Recorder ¼Ç¼ÏÂÀ´µÄÃüÁîÊÇÕâÑùµÄ
Rows("1:6").Selection
ËùÒÔ×Ô¼ºÐ´´úÂëµÄʱºò¾Í³ÉÁË
Rows("start:end").Selection
½á¹ûDebugµÄʱºò¾ÍËÀ»î²»Èùý£¬ËµÊÇÐÎʽ²»·û
¿ªÊ¼ÒÔΪÊÇintergerºÍstringµÄÎÊÌâ
ºóÀ´ÕÒת»¯µÄ·½·¨£¬
¿ªÊ¼È¥msdnÉÏÃæÕÒÕÒ²¹µ½£¬µ½ÍøÉÏÈ¥ËÑË÷Æ«·½ÓÖËÑË÷²»µ½£¬
ºóÀ´ÎÊÁ˵ÛÊÍÌìÓÖÎÊseanºóÀ´»¹À°æÖ÷³½ÐÇÀ´ÎÊ
½á¹û´ó¼Ò¶¼¶ÔVB²»Êì
×îºó²éOffice×Ô´øµÄhelp
½á¹ûexcel¸æËßÎÒ£¬ÄãûÓа²×°°ïÖú£¬ÊÇ·ñÒª°²×° =.=
ÓôÃÆ£¬½á¹ûÓÖÔÚÍøÉϵ½´¦ÕÒÆ«·½¡«¡«¡«¡«
×îºóʵÔÚ²»ÐÐÁËbebugÁË4¸öСʱ £½¡££½
ÐÄÒ»ºá
È¥ÍøÉÏÕÒMSµÄOFFICE°ïÖúÎļþ£¬¿´¿´ÓÖûÓеÄÏÂÔØ
½á¹ûÔÚ΢ÈíÖ÷Ò³ÉÏÕÒµ½ÁË £½¡££½
ÏÂÔØÏÂÀ´¿´¹ýÀ´¿´¹ýÈ¥ÖÕÓÚÕÒµ½ÁË rows property £½¡££½
µ«ÊÇÀïÃæ¸ù±¾Ã»ÓÐʲôѡȡ´Órow Aµ½row BµÄ¶«Î÷
£¡££
ÀïÃæÖ»ÓÐÁ½¸örows(a)ºÍrows
rows´ú±ísheetÀïÃæµÄËùÓÐrow...
È»ºó¿´µ½ÏÂÃæÒ»ÐÐС×Ó£¬Èç¹ûÏëҪѡȡÁ¬ÐøµÄ¶àÐеĻ°ÇëʹÓÃ×Ô¶¨ÒåµÄunion £½¡££½
º¹¡£¡£¡£¡ (more...)
msdn must have right? just need time and patience to find
You may say I'm a dreamer
but I'm not the only one...