VBA: Find specific value in a static range and adjust x-axis maximum of a chart based on found value

[LukiiMaxim96]

Hi.. I need a little bit help with that one.

I managed to write a VBA code to copy paste the range C7:AX10 from another workbook and now, I would like to have the chart's x-axis automatically adjusted to the maximum value "100" which would be in AI8.

This is my start so far..:
Range("C8:AX8").Find("100")

I do not now how to continue. Every hint is appreciated.
Thank you.

 

[LukiiMaxim96]

"Progress" or workaround for everyone interested

OpenBook.Sheets(2).Range("C8:AX10").Replace _
What:="0%", Replacement:=""
    
OpenBook.Sheets(2).Range("C8:AX10").Replace _
What:="#N/A", Replacement:=""