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

[µo°Ý] VBA ·j´M¸ê®Æ¦C¹ïÀ³ªº³Ì¤j­È©Î³Ì¤p­È

¦^´_ 10# junkwei
"=EX" ¦p¨S³o¤½¦¡¶Ç¦^¿ù»~­È "#NAME?"

½Ð¸Ô¬ÝVBA ªº»¡©ú
  1. SpecialCells ¤èªk
  2. expression.SpecialCells(Type, Value)
  3. expression      ¥²¿ï¡C¸Ó¹Bºâ¦¡·|¶Ç¦^ [®M¥Î©ó] ²M³æ¤¤ªº¨ä¤¤¤@­Óª«¥ó¡C
  4. Type     ¥²¿ïªº XlCellType¡C­n¥]§tªºÀx¦s®æ¡C
  5. XlCellType ¥i¥H¬O³o¨Ç XlCellType ±`¼Æ¤§¤@¡C
  6. xlCellTypeAllFormatConditions¡C  ¥ô¦ó®æ¦¡ªºÀx¦s®æ
  7. xlCellTypeAllValidation¡C¨ã¦³ÅçÃÒ·Ç«hªºÀx¦s®æ
  8. xlCellTypeBlanks¡CªÅÀx¦s®æ
  9. xlCellTypeComments¡C¥]§tµù¸ÑªºÀx¦s®æ
  10. xlCellTypeConstants¡C¥]§t±`¼ÆªºÀx¦s®æ
  11. xlCellTypeFormulas¡C¥]§t¤½¦¡ªºÀx¦s®æ
  12. xlCellTypeLastCell¡C¤w¥Î½d³òªº³Ì«á¤@­ÓÀx¦s®æ
  13. xlCellTypeSameFormatConditions¡C  ¦³¬Û¦P®æ¦¡ªºÀx¦s®æ
  14. xlCellTypeSameValidation¡C  ¦³¬Û¦PÅçÃÒ·Ç«hªºÀx¦s®æ
  15. xlCellTypeVisible¡C©Ò¦³¥i¨£Àx¦s®æ

  16. Value     ¿ï¾Ü©Êªº Variant¡C¦pªG Type ¬° xlCellTypeConstants ©Î xlCellTypeFormulas ¤§¤@¡A¦¹¤Þ¼Æ¥i¥Î©ó½T©wµ²ªG¤¤À³¥]§t­þ´XÃþÀx¦s®æ¡C±N¬Y´X­Ó­È¬Û¥[¥i¨Ï¦¹¤èªk¶Ç¦^¦hºØ«¬ºAªºÀx¦s®æ¡C¹w³]±¡ªp¤U±N«ü©w©Ò¦³±`¼Æ©Î¤½¦¡¡A¹ï¨ä«¬ºA«h¤£¥[Ãþ«¬¡C¥i¬°¤U¦C XlSpecialCellsValue ±`¼Æ¤§¤@¡G

  17. XlSpecialCellsValue ¥i¥H¬O³o¨Ç XlSpecialCellsValue ±`¼Æ¤§¤@¡C
  18. xlErrors
  19. xlLogical
  20. xlNumbers
  21. xlTextValues
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_  junkwei
"=EX" ¦p¨S³o¤½¦¡¶Ç¦^¿ù»~­È "#NAME?"

½Ð¸Ô¬ÝVBA ªº»¡©ú
GBKEE µoªí©ó 2014-12-15 07:10



·PÁÂGBKEE ª©¥Dªº»¡©ú
­ì¨Ó¥u­n¶ñ¤J¿ù»~ªº¤½¦¡Åý¥L¦^¶Ç¿ù»~­È´N¥i¥H¤F
¦p¦¹¥i¥H¦b¯S®íªº½d³ò¸Ì§@·~
·Pı³o¯uªº«Ü¹ê¥Î
ÁÂÁ«ü¾É~~!

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD