| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch problem
I have a date in both B1 and B2 (sheet "Macro Data"). In my macro, I have the
following code: Dim EndDate As Date Dim StartDate As Date StartDate = Sheets("Macro Data").Cells("B1") EndDate = Sheets("Macro Data").Cells("B2") The above statements are giving me error 13 (type mismatch). What's wrong with my statements? How do I reference the date data in my macro? Thanks! Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Type mismatch problem
Instead of: StartDate = Sheets("Macro Data").Cells("B1") Try: StartDate = Sheets("Macro Data").Cells("B1").Value -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=546956 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Type mismatch problem
Dan wrote: My English is very bad. I hope you can understand what I say . The type of "CellS()" is wrong. The Correct is "Cells(row,column)" StartDate = Sheets("Macro Data").Cells(2,1) EndDate = Sheets("Macro Data").Cells(2,2) or you can use StartDate = Sheets("Macro Data").Range("B1") EndDate = Sheets("Macro Data").Range("B2") Aheng MSN: |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Type mismatch problem
|
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Type mismatch problem
When I use
StartDate = Sheets("Macro Data").Range("B1").Value it works. If I use StartDate = Sheets("Macro Data").Cells("B1").Value I get the type mismatch error. This is my first attempt to use macros in Excel. What is the difference between Range and Cells? Dan " wrote: You can also do sheets("Macro Data").range("A2") wrote: wrote: Sorry, The previous has some wrong, The correct is StartDate = Sheets("Macro Data").Cells(1,2) Aheng MSN: |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Type mismatch problem
Cells requires the row/col co-ordinates - see the examples above, range
will allow a text string Dan wrote: When I use StartDate = Sheets("Macro Data").Range("B1").Value it works. If I use StartDate = Sheets("Macro Data").Cells("B1").Value I get the type mismatch error. This is my first attempt to use macros in Excel. What is the difference between Range and Cells? Dan " wrote: You can also do sheets("Macro Data").range("A2") wrote: wrote: Sorry, The previous has some wrong, The correct is StartDate = Sheets("Macro Data").Cells(1,2) Aheng MSN: |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Type mismatch problem
Okay. That's helpful. Thanks!
Dan " wrote: Cells requires the row/col co-ordinates - see the examples above, range will allow a text string Dan wrote: When I use StartDate = Sheets("Macro Data").Range("B1").Value it works. If I use StartDate = Sheets("Macro Data").Cells("B1").Value I get the type mismatch error. This is my first attempt to use macros in Excel. What is the difference between Range and Cells? Dan " wrote: You can also do sheets("Macro Data").range("A2") wrote: wrote: Sorry, The previous has some wrong, The correct is StartDate = Sheets("Macro Data").Cells(1,2) Aheng MSN: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Type mismatch problem in array - ?? | Excel Programming | |||
| Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
| Type mismatch error problem when dealing with Strings | Excel Programming | |||
| Type Mismatch Problem | Excel Programming | |||
| Type mismatch problem? | Excel Programming | |||
Linear Mode
