Searching for user defined value in range, sending only these values to array ERROR

For some reason my code compiles, but it won't insert anything into the sheet ArrayData for the Chart Generation....This section I speak of is towards the end of the code with a For/If loop...

Since there are many values and excel's series input has a character limit of 255, I am putting these values in an unused sheet....but they aren't showing up when the code writes... and now when I corrected my reference to sheet for the range before the loop seen below where it is all caps...I get an error saying Application-defined or object defined error

Please Login or Register  to view this content.

It's confusing having a string variable called sheet. It's too similar to all the other Sheets references.

Is there an existing sheet with the same tab name as your variable sheet value?

If yes, you may want to define your range like this...
Set slotRang = Worksheets(sheet).Range("P2", Worksheets(sheet).Range("P2").End(xlDown))