Page 1 of 1
Changing the Selected Cell or Area
Posted: Mon Feb 11, 2008 11:07 am
by Ian Wakeling
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?
Posted: Mon Feb 18, 2008 12:44 pm
by larsa
Hello
Use the XLS.Sheets[0].SelectedAreas property.
Lars Arvidsson
Posted: Mon Feb 18, 2008 1:28 pm
by Ian Wakeling
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.