Due to an unforeseen problem I have reset my Bios in the mobo and end up with the same error of

"Error 18: Selected cylinder exceeds maximum support by BIOS"

I discovered the hard disks were read in a mode different to LBA after the reset. After I fixed the Bios I still got the problem. I managed to ask Grub to display the /boot/grub/menu.lst of the partition I want to boot and manually typed in each line of command to get the Linux booted.

So try it yourself.

Say if you want to boot a Linux in the 56th partition of the 2nd disk it will be (hd1,55)
Code:
root (hd1,55)
cat /boot/grub/menu.lst
Then just type each line starting from the "kernel" statement, then "initrd" line and finish with the "boot" statement.