Hi all... I'm encountering the following error when the sub below encounters a blank cell. Can't Call method "Value" on an undefined value". When I error capture using Win32::GetLastError I get Error: 0. As long as the cells are not empty the sub works fine. Essentially I'm attempting to extract a subset of the data from a spreadsheet that contains 3000 rows and 25 columns. I use an pattern search to see if a specific cell in each row contains the data I want and if true the data from that row is added to an array. If $CellRefValue returns an empty cell I encounter the undefined error. Any insight would be greatly appreciated. pc

I figured this problem out about 5 minutes after posting the issue...I switched to using {Val} rather than {Value}. pc

I figured this problem out about 5 minutes after posting the issue...I switched to using {Val} rather than {Value}. pc