Hi everyone.
I will start with the code:
ItemCell is a string, and this code works fine if ItemCell Equals something like "E5".VB Code:
ItemCellDbl = CDbl(Worksheets("MEDIA").Range(ItemCell).Text)
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:
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 ?




Reply With Quote