Hi I like to get the value of last cell in column A in a excelsheet call "Freight"" but i keep getting error message Object reference not set to an instance of an object.",..Can Help?

[royang28]

My image is attached as above. Appreciate your answers.

[AlphaAmsyar (Aqil Amsyar)]

Hi there!

Have you entered the correct data table name in your read range output?
Let me know if the problem presist.

[royang28]

@AlphaAmsyar

rrect data table

Yes. after i key in the output data table . No more error but Result is blank

[Yoichi]

HI,

Can you try the following expression?

lines = dt.AsEnumerable.Where(Function(r) r isnot Nothing AndAlso not String.IsNullOrEmpty(r(0).ToString)).Last().Item(0).ToString

Regards,

[royang28]

Thanks Guys, i got is solved by removing activities "read range"range A:A. However i still do not understand as the output i want is from column a.

[Yoichi]

HI,

Can you try to replace the red arrow pointed expression in the following image with the following?
(Please keep to use ReadRange)

dtData.AsEnumerable.Where(Function(r) r isnot Nothing AndAlso not String.IsNullOrEmpty(r(0).ToString)).Last().Item(0).ToString

Regards,

[royang28]

Yes.Thank you.Yochi.
This is a solution.