Thought it worked… it doesn’t. It if i use the cdbl method it return error that it in overcapacity. So i thought adding the row.item(10) in there would solve it. Well it did solve the issue, but if i run it gives me a syntax error:
Assign : Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Any other suggestions on this?
Sorry to keep bothering you with this. but i really want to get trough this part!
EDIT: I’m guessing the cdbl makes a double value out of it. I never worked with these so i’m searching for DBNull variably change now… Just thinking out loud, that this might work.
I had empty cells. which returned this value. i ignored those and it worked perfect!