Changing the Selected Cell or Area

Ian Wakeling · Post by **Ian Wakeling** » Mon Feb 11, 2008 11:07 am

I would like to set a specific cell or range of cells on a worksheet to be selected when then the user opens a workbook. Can anyone give me some example code?

Post by **larsa** » Mon Feb 18, 2008 12:44 pm

Hello

Use the XLS.Sheets[0].SelectedAreas property.

Lars Arvidsson

Ian Wakeling · Post by **Ian Wakeling** » Mon Feb 18, 2008 1:28 pm

Hello Lars,

It must be obvious, but I am just not seeing what I have to do.

If I use syntax like:

XLS.Sheets[0].SelectedAreas.Add(1,1,5,10);

then can you tell me what I have to do to make that area the current selection?

Many thanks,

Ian.