Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everyone,
I have a program that opens an excel template and then checks to see if the first sheet is selected, if it is then no error but i get an error irrespective of the fact whether the first is selected or not...i am pasting the code here and would appreciate it if someone can point what i am missing. TIA #region Excel Check 5: First sheet or multiple sheets selected if(OptionsData.XLCheckSelectedSheet)----(bool) { if(XLwb.Sheets.Count 1 && XLwb.ActiveSheet != XLwb.Sheets.get_Item(1)) { ErrorCounter++; ProcessError(ErrorCounter, "The first sheet is not the selected sheet"); } |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sheet selected, automatic return to top of sheet | Excel Worksheet Functions | |||
copying only selected data from Sheet 1 to Sheet 2 | Excel Worksheet Functions | |||
Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
how to use sumif function to check date in 1 sheet is < 2 sheet | Excel Worksheet Functions | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions |