Vba gets two different ranges

  .Chart.SetSourceData Source:=Sheet3.Range("B2:C8,I2:I8"), PlotBy:=xlColumns

how to replace C8 and i8 with Sheet3.[ b2] .CurrentRegion.Rows.Count to connect

Vba
Mar.11,2021
Menu