Logo hmn.boatexistence.com

Ntawm qhov yuam kev subscript tawm ntawm ntau yam?

Cov txheej txheem:

Ntawm qhov yuam kev subscript tawm ntawm ntau yam?
Ntawm qhov yuam kev subscript tawm ntawm ntau yam?

Video: Ntawm qhov yuam kev subscript tawm ntawm ntau yam?

Video: Ntawm qhov yuam kev subscript tawm ntawm ntau yam?
Video: Kablia vwj xyov koj yuam kev los kuv yuam kev Nkaujtawm tshiab 2024, Tej zaum
Anonim

Subscript out of Range yuam kev tshwm sim thaum koj sim siv qhov Index rau ib qho kev sau uas tsis raugFeem ntau, qhov ntsuas hauv Windows tsis suav nrog. xls ua. Qhov Performance index rau lub qhov rais yuav tsum yog tib yam li lub npe ntawm phau ntawv ua haujlwm pom nyob rau hauv lub npe bar ntawm Excel.

Yuav ua li cas koj daws subscript tawm ntawm ntau yam yuam kev?

Yuav kho 'Subscript Out of Range' yuam kev hauv Visual Basic rau…

  1. Subscript out of range yuam kev.
  2. Array hauv VBA Excel.
  3. Siv Dim thiab ReDim los qhia cov naj npawb ntawm cov ntsiab lus.
  4. Siv "Rau Txhua…Next" tsim.
  5. Siv lub npe siv tau.

txhais li cas thaum Excel hais subscript tawm ntawm ntau yam?

"Subscript out of range" qhia tias koj tau sim nkag mus rau ib lub ntsiab lus los ntawm kev sau uas tsis muaj nyob. Puas muaj "Sheet1" hauv koj phau ntawv ua haujlwm? Yog tias tsis yog, koj yuav tsum hloov qhov ntawd mus rau lub npe ntawm daim ntawv ua haujlwm uas koj xav tiv thaiv.

Lub sijhawm ua yuam kev 9 subscript tawm ntawm qhov ntau txhais li cas?

Yog tias koj tau txais cov lus hais tias "Khiav-lub sijhawm yuam kev 9: Subscript tawm ntawm ntau yam," uas txhais tau tias Visual Basic tsis tuaj yeem nyeem cov lus txib Qhov yuam kev no feem ntau tshwm sim yog tias koj sim luam cov nplooj ntawv rau hauv cov ntaub ntawv Excel. Lwm qhov laj thawj tuaj yeem yog tias koj tsis muaj lub tshuab luam ntawv tsis raug ntawm koj lub computer.

Kuv yuav kho lub sijhawm ua haujlwm yuam kev hauv Excel li cas?

Nyob hauv Excel, ntawm lub taskbar, xaiv cov ntaub ntawv tab, ces nias sab laug Qhib los ntawm cov npe tau muab. Tam sim no nyem rau ntawm cov ntaub ntawv xav tau thiab xaiv Qhib -> Qhib thiab rov qab -> Restore (koj tuaj yeem xaiv qhov Extract cov ntaub ntawv tab). Yog tias txhua yam mus zoo, runtime yuam kev 13 yuav tsis thab koj dua.

Pom zoo: