Hi ,
I need to store the row number of selected cell in a array which i have coded in Workbook_SheetChange event.The array has been intialized in Module and I'm using the reference of that array in ThisWorkbook.Workbook_SheetChange event.But not able to store the all the row no of the selected cells ,Its throwing error as Type Mismatch
Please help any suggestion .
In Module i have declared the array as
In the Workbook_SheetChange eventPlease Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks