[RESOLVED] flexgrid to excel problem

I am using the code given at this link to export the data from flex grid to excel
http://www.vbforums.com/showthread.php?t=393082
But it is showing an error at this line as Invalid Column value
.ColSel = .Cols – 1
Can someone please guide me how to fix the problem?

Are you selecting a larger range then whats allowed?

Quote:

---

'Select maximum allowed (your selection shouldnt be greater than this)

---

Thanks for the reply Actually I need to adjust .Cols - 1 to .Cols - 2 and it worked.