[RESOLVED] object value set to nothing

[india123]

IT gives error
object value set to nothing what is wrong

MyScreen.Area(1,10,1,14).Value = Trim(aSheet.Cells(4, "e"))

[india123]

i have in cell 4 e has ABCD BUT SPACES BEFORE A AND AFTER.
I TRIED BELOW THE CODE
BUT STILL I HGOT object value set to nothing

[india123]

Westconn
why it is coming error in the
MyScreen.Area(1,10,1,14).Value = Trim(aSheet.Cells(4, "e"))
what is the problem in that
before this code i have len statiment

[NeoDan]

Westconn
why it is coming error in the
MyScreen.Area(1,10,1,14).Value = Trim(aSheet.Cells(4, "e"))
what is the problem in that
before this code i have len statiment

Hi there.

when referencing cells in excel from VBA there are two conventions -

asheet.cells(4,5).value

or

asheet.range("e4").value

You are mixing the two conventions and this is probably the reason it doesn't work.

hope this helps
Cheers

[india123]

Still the same problem it is not resolved
MyScreen.Area(1,10,1,5).Value = aSheet.range("e4").value