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

Kotlin
IOS
VB.Net
SQL
Node.js
Swift
Ruby
Go
Oracle
Git
Laravel
Mongodb
Asp.Net
More...

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

False
Django, Why does the system automatically generate an empty session? every time the request is made?
Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.
How to self-start the php-fpm service when building a LNMP environment with docker?
Can an array in react state be bound to a dom state using an element in the array?
Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.
In express+hbs, how do you define the routed data as a variable on the page?
How to use symbol reference of Iconfont in dva
How to elegantly add data to JSON objects?
Using node to build video streaming server
The proportional width of the echarts graph is inconsistent.
React uses axios to call the background data. After success, how to jump to the page based on the returned value?
I don't understand what a linux command means. Please explain it.
Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.
Running nodejs reports fewer errors ")"

How can the public network access a site on the local area network?
Calling functions in the python class
Etherfang set up a private chain and began to dig mines to appear OOM. Memory keeps growing until the geth process is killed
When downloading the app, developed by the server, the mobile browser prompts that there is a problem with the parsing package?
Python3 ip address to int algorithm