03-14-2003, 08:43 AM
Hi, I have a listbox that displays all the sheets in an excel document. Is there a way to select multiple sheets and do different calculations with the cells? Example: I have data that I want to add up on 4 different sheets, how would I do that? Thanks for your help.
03-14-2003, 08:58 AM
You should be able just to reference each sheet by name for instance if you want to take a value from a cell on Sheet one and add it to a value from a cell on Sheet Two this would do it:
appExcel.Worksheets("Sheet One").Cells(Row, Column).Value + appExcel.Worksheets("Sheet Two").Cells(Row, Column).Value