Hi everyone.
I will start with the code:
VB Code:
  1. ItemCellDbl = CDbl(Worksheets("MEDIA").Range(ItemCell).Text)
ItemCell is a string, and this code works fine if ItemCell Equals something like "E5".
If ItemCell Equals "Cells(6, 30), Cells(6, 30)" I get an error:
Run-time error '1004':
Application-defined or object-defined error.

What is strange though is that the following code works just fine:
VB Code:
  1. Debug.Print CDbl(Worksheets("MEDIA").Range(Cells(6, 30), Cells(6, 30)).Text)

Does maybe ItemCell being a string have anything to do with this error ?