Overflow Error but no idea how - using Variants for arrays

[TheRedCardinal]

I have a commonly used bit of code that loads a whole worksheet into an array for data manipulation.

It looks like this:

Set WBk1 = ThisWorkbook
Set WS1 = WBk1.Sheets("5. Purchases")
Set WS2 = WBk1.Sheets("10. Input Summary")
Set WS3 = WBk1.Sheets("1. Start")

Dim PurchaseData As Variant, Inputs As Variant, TCodes As Variant

PurchaseData = WS1.UsedRange
Inputs = WS2.Range("InputSummary")

I'm getting an overflow error on the "PurchaseData = WS1.UsedRange" line - the used range, confirmed by checking in Immediate is 16 columns by 4360 rows, and much smaller than other instances of using this process.

Can anybody see what I've done wrong here?

 

[RoryA]

Does it work if you use:

PurchaseData = WS1.UsedRange.value2

 

[TheRedCardinal]

Solved it now - there was a value in the column that was a number but too big (I think) - fixed it by converting that column to text.