Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Micorsoft Excel

Status
Not open for further replies.

rambob

Programmer
Feb 25, 2002
8
US
I'm sure this is simple but I can't seem to be able to find the way in Excel to retrieve a cell value. I continue to get a type mismatch error (I'm using a macro) with the following:

Dim cell

cell = Worksheets("Sheet1").Range("E25").Value
 
Cell is a key word and can not be used within the confines of Excel. Try using a different variable name. Matt Smith

No two nulls are the same
 
That code should be ok. Are you sure that there is nothing else causing the problem. Could you provide some more of teh code from the procedure producing the error.

AC
 
Thanks for the responses. It turns out it was a different statement causing the error...this one seems to work OK. Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top