½ñÌìºÍ´ó¼Ò·ÖÏíÒ»¸öìÅ¿áµÄͼ±í¼¼ÇÉ£¬ÏÈ¿´Ð§¹û£º![]() Ö»Òª¹â±ê»¬¹ý²»Í¬µÄÉÌÆ·Ãû³Æ£¬Í¼±í¾Í»á×Ô¶¯±ä»¯£¬ÊDz»ÊǺÜìſᰡ¡£ ²½ÖèÒ»£º×¼±¸Êý¾ÝÔ´ ![]() ²½Öè¶þ£ºÊäÈë´úÂë Alt+F11 ´ò¿ªVBE´°¿Ú£¬¡¾²åÈë¡¿→¡¾Ä£¿é¡¿ ¸´ÖÆÈçÏ´úÂ뵽ģ¿éÖУ¬Í˳öVBE´°¿Ú£º Function techart(rng As Range) Sheet1.[g1] = rng.Value End Function ![]() ²½ÖèÈý£ºÊäÈ빫ʽ ÔÚG1µ¥Ôª¸ñÖÐÊäÈëÈÎÒâÒ»¸öÉÌÆ·Ãû³Æ£¬ÈçÅ£×п㡣 G2ÊäÈ빫ʽ£¬ÏÂÀÖÁG13£º ![]() Ñ¡ÖÐG1£ºG13£¬¡¾²åÈë¡¿→¡¾ÕÛÏßͼ¡¿ ![]() ²½ÖèËÄ£ºÃÀ»¯Í¼±í ÉèÖÃÕÛÏßͼΪÎÞÏßÌõ¡£ ÉèÖÃÊý¾ÝµãÑùʽ£¬Ìí¼Ó´¹Ö±Ïß¡£ ´Ë´¦Ê¡ÂÔ¾ßÌå²½Ö裬´ó¼Ò¿ÉÒÔ¸ù¾ÝÐèÒªºÍϲºÃ£¬ÉèÖóö²»Í¬Ñùʽ²»Í¬·ç¸ñµÄͼ±íÑùʽ¡£ ×îÖÕЧ¹ûÈçÏ£º ![]() ²½ÖèÎ壺ÊäÈ빫ʽÔÚͼ±íÉÏ·½£¬ÊäÈëÄ£Äâͼ±í±êÌâµÄ¹«Ê½¡£ =G1&"2015ÄêÏúÊÛÇ÷ÊÆ" ÔÚͼ±íÏ·½£¬ÊäÈëÄ£Äâ×ø±êÖáµÄ¹«Ê½¡£ ±¾ÀýÒÔJ15:K16µ¥Ôª¸ñÇøÓòΪÀý£¬ÒÀ´ÎÊäÈëÒÔϹ«Ê½£º =IFERROR(HYPERLINK(techart(B1)),"¡ô"&B1&"¡ô"&REPT(" ",99)) =IFERROR(HYPERLINK(techart(C1)),"¡ô"&C1&"¡ô"&REPT(" ",99)) =IFERROR(HYPERLINK(techart(D1)),"¡ô"&D1&"¡ô"&REPT(" ",99)) =IFERROR(HYPERLINK(techart(E1)),"¡ô"&E1&"¡ô"&REPT(" ",99)) ÊäÈ빫ʽºóµÄЧ¹ûÈçÏ£º ![]() ¹«Ê½ºóÃæÎªÊ²Ã´ÒªÁ¬½ÓREPT("",99)ÄØ£¿ Èç¹ûÖ»Êǵ¥¶ÀÏÔʾ·ÖÀàµÄ»°£¬Êó±êÐèҪͣµ½ÎÄ×ÖÉϲŻá±ä»¯£¬ËùÒÔʹÓÃ99¸ö¿Õ¸ñռ룬Êó±êֻҪͣÔÚµ±Ç°·ÖÀ൥Ԫ¸ñÈÎÒâÒ»¸öµØ·½£¬¶¼¿ÉÒÔ´¥·¢´úÂëÔËÐС£ ½«Îļþ±£´æ³ÉÆôÓúêµÄÎļþ£¨xls¡¢xlsm£©£¬OKÀ²£¡ ![]()
ϸ·Ö£º
ͼ±í
×ªÔØÇë×¢Ã÷À´Ô´"ExcelHome"²¢±£ÁôÔÎÄÁ´½Ó¡£¹Ì¶¨Á´½Ó£ºhttps://www.excelhome.net/lesson/article/excel/1955.html |