ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¥Î°}¦C¼g¤j¶q¸ê®Æ¹Bºâ

¦p¦ó¥Î°}¦C¼g¤j¶q¸ê®Æ¹Bºâ

¦pªþ¥ó
©ósheet1ªºbÄ榳300µ§¸ê®Æ
©ófÄæ¤]¦³300¤ñ¸ê®Æ
§Æ±æbÄæ­¼¤WfÄ檺µª®×Åã¥Ü©óhÄæ
¦p¦ó¥Î°}¦C¼g?

990903-1.rar (5.9 KB)

Sub yy()
[h2:h302] = [b2:b302*f2:f302]
End Sub

TOP

¦^´_ 2# oobird


    Ô£???
³o¼Ë´N¥i¥H???
·P®¦³á~~~

TOP

«Ü²¼äªº¼gªk~~~

·Q½Ð±Ðª©¥Dªº¬O
°²³]»Ý¨D¦P­ì°ÝÃD¡A¦ý¸ê®Æªø«×¤£½T©w¡A¤]´N¬O:
BÄæ¤ÎFÄ檺¸ê®Æ¦³N¦C
B¡AFªº­¼¿n§e²{©óHÄæ
¤]¯à¥Î¦¹¤¤¬A¸¹ªº°}¦C¼gªk¶Ü?

ÁÂÁ¸Ѵb~

TOP

¦^´_ 4# gstone

¤¤¬A¸¹¬OOLE¼gªk
¥²¶·¬O±`¼Æ¦WºÙ
¤£¥i¨Ï¥ÎÅܼÆ
©Ò¥HÅܰʽd³òªº¸Ü§A¥²¶·¨Ï¥Î©w¸q¦WºÙ
©w¸q3­Ó¦WºÙ
x=OFFSET(Sheet1!$B$2,,,COUNTA(Sheet1!$B:$B),)
y=OFFSET(Sheet1!$F$2,,,COUNTA(Sheet1!$B:$B),)
z=OFFSET(Sheet1!$H$2,,,COUNTA(Sheet1!$B:$B),)

µ{¦¡½X
Sub nn()
[Z].Value = [x*y]
End Sub
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂHsiehª©¥D
¤w¤F¸Ñ¤¤¬A¸¹¦³­­¨î¡C

­è¤~´ú¸Õ6¸U¦hµ§¸ê®Æ
­Y¬OÅܰʽd³ò
¥Î©w¸q¦WºÙ¤ñ¥Î°j圏¼g¤J°}¦C
³t«×§Ö¤F5¡B6­¿
¨þ~«Ü¦nªº¤èªk~~~

TOP

¸Õ¥X¤£¥Î©w¸q¦WºÙªº¼gªk:
Range("H2:H" & [B65536].End(xlUp).Row) = [B2:B65536*F2:F65536]

Áö¤£©ú¨ä¦]¡A¦ý­pºâµ²ªG¤Î³t«×©M©w¸q¦WºÙ¤@¼Ë¡C

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD