???? VBA .SpecialCells(xlCellTypeBlanks) ?? ???? ??? ?? ????? ?? Excel

?????? ????????? ?????? ?????????
???? ???????: 832293 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

??? ????? Microsoft Visual Basic for Applications (VBA) ??????? ???? ???? ??? ?????? ??? ??????? ?? Microsoft Excel ???? ?????? ?????? ????? VBA ???? ????????? ???????, ???? ?? ??????? ??? ???? ?? ??????? ??? ????????? ??? ?? ???? ?? ??????? ?????? ??? ???? ?????: ????? .SpecialCells(XlCellType). ??????? XlCellType ???? ?? ????
expression.SpecialCells(XlCellType).expression XlCellType
?? ??? ???:
  • xlCellTypeAllFormatConditions
  • xlCellTypeAllValidation
  • xlCellTypeBlanks
  • xlCellTypeComments
  • xlCellTypeConstants
  • xlCellTypeFormulas
  • xlCellTypeSameFormatConditions
  • xlCellTypeSameValidation
  • xlCellTypeVisible

?????

???? ??? ?????? ??? ??? ?????? 8,192 ???? ?? ??????? ??? ????????? ?? ??????? ????? ??. ???? Excel ??? ???? ?? ????? ??? ????????? 8,192 ??? ????? ????? VBA.

???? ???? ??? ????? ????? ??????? ??? ????????? 8,192 ???? ?? ?????? ???? ????? ????? ???????:
??????? ???? ????.
??? ???? ??? ??????? ????? VBA ???? ??? ?? ????? ?????? ????? ??? ????? ??? ??? ????? ?? ??? ????? ???? ???? ?????? ???? ????? ??????? ??.

???? ??????

??????? ?????? ??? ??? ???????? ?? ???? ?? ????? ???? looping ?? ??????? ????? ?? VBA ????? ??? ?? ??????? 8,192 ???? ??????.

?????

????? ??? ?????? ??? ???????.

???????

???? ???????: 832293 - ????? ??? ??????: 19/????/1427 - ??????: 2.2
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
????? ??????: 
kbmt kbvba kbfunctions kbformat kbmacro kbcodesnippet kbcode kbprb KB832293 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????832293

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com