frubeng
05-29-2009, 05:22 AM
Hello,
I have named cells on my spreadsheet. These are named: vo_a, vo_b
In my code, I have the following lines
If IsNumeric(Workbooks("Outlier").Sheets("Spreadsheet").range("vo_a")) Then
vo_a = Workbooks("Outlier").Sheets("Spreadsheet").range("vo_a").Value
End If
If IsNumeric(Workbooks("Outlier").Sheets("Spreadsheet").range("vo_b")) Then
vo_b = Workbooks("Outlier").Sheets("Spreadsheet").range("vo_b").Value
End If
These both give me: "Subscript out of range errors". The workbook and sheet names are definitely right.I have other named cells creating the same error.
What really puzzles me is that is was working fine 2 weeks ago when i last opened the workbook.
Any ideas? Thanks!!
I have named cells on my spreadsheet. These are named: vo_a, vo_b
In my code, I have the following lines
If IsNumeric(Workbooks("Outlier").Sheets("Spreadsheet").range("vo_a")) Then
vo_a = Workbooks("Outlier").Sheets("Spreadsheet").range("vo_a").Value
End If
If IsNumeric(Workbooks("Outlier").Sheets("Spreadsheet").range("vo_b")) Then
vo_b = Workbooks("Outlier").Sheets("Spreadsheet").range("vo_b").Value
End If
These both give me: "Subscript out of range errors". The workbook and sheet names are definitely right.I have other named cells creating the same error.
What really puzzles me is that is was working fine 2 weeks ago when i last opened the workbook.
Any ideas? Thanks!!