VBA processes chart,SeriesCollection.Values errors when the data selection of the original chart exceeds the real data area.

excel has a chart, line chart.
assume that the data selection is Range ("B1:B10")
if cell B10 is empty,
reads Sheet1.ChartObjects (1) .Chart.SeriesCollection (1) .values Times error.

I guess the reason is the blank lines at the end of
, for example, B10 is empty and empty, but this line does not exist. Reading is wrong.
but why manual drawing can be selected, vba read error.

in addition

1. How to solve this problem?

2. How does vba get the selection range? of chart data

Chart vba

Mar.14,2021

Previous: How to solve the problem that there is an extra blank when the web page shrinks?

Next: How to configure these two attributes in the new version of spring-boot-starter-data-redis

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e44b2c-44316.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e44b2c-44316.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?