Good afternoon,


My macro generates a spreadsheet. How do I activate this sheet determines worksheet to check and make value comparisons. I'm using this:

Application.Workbooks (Spath & filename & ". Xls"). Worksheets ("AF"). Select

But generates runtime error 9 - Subscript out of range. I thought about closing the spreadsheet the macro after taking her values​​, but also the macro closes well. As macro to show that the cells in question are given sheet of the spreadsheet created and saved by the macro? Another question is also: Cells (1,3). Value also applies when you are in the cell for text? Thank you!