load the data of the column that you want to check the column(sort data) into the datatable global sheet and then compare the values row1 with row2 and row2 with row3 and so on
Code:
dim x,i,k,flag
flag=false
k=1
rowcount=datatable.rowcount
for i=1 to rowcount
datatable.setcurrentrow i
x=datatable.value("column header",dtglobalsheet)
if x>k then
k=x
flag=true
else
msgbox "your result is fail"
exit for
end if
next
if flag=true then
msgbox "the data is sorted"