@pprin001 I got your problem
Let me explain range.
When we use range as “A1:C3”
It means we are getting specific block of data.
But when you don’t know about data.
Then we are using
“A1:” it will read end of data and its flexible
1 Like