| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch error
Hi All, I am trying to update two sheets in different workbooks with the same
user input accepted through userform and I am getting a type mismatch error. Here is where I am getting the error: If Male.Value = True Then ws.Cells(iRow, 2).Value = "Yes" And wst.Cells(2, 2).Value = "Yes" End If ws and wst are two seperate sheets in two seperate workbooks. Thanks in Advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
type mismatch error
hi Sam,
try it this way: If Male.Value = True Then ws.Cells(iRow, 2).Value = "Yes" wst.Cells(2, 2).Value = "Yes" End If -- jb "sam" wrote: Hi All, I am trying to update two sheets in different workbooks with the same user input accepted through userform and I am getting a type mismatch error. Here is where I am getting the error: If Male.Value = True Then ws.Cells(iRow, 2).Value = "Yes" And wst.Cells(2, 2).Value = "Yes" End If ws and wst are two seperate sheets in two seperate workbooks. Thanks in Advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
type mismatch error
that works great! Thank you
"john" wrote: hi Sam, try it this way: If Male.Value = True Then ws.Cells(iRow, 2).Value = "Yes" wst.Cells(2, 2).Value = "Yes" End If -- jb "sam" wrote: Hi All, I am trying to update two sheets in different workbooks with the same user input accepted through userform and I am getting a type mismatch error. Here is where I am getting the error: If Male.Value = True Then ws.Cells(iRow, 2).Value = "Yes" And wst.Cells(2, 2).Value = "Yes" End If ws and wst are two seperate sheets in two seperate workbooks. Thanks in Advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| runtime error 13 - type mismatch error in Excel 97 on Citrix | Excel Programming | |||
| Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
| Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
| Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Linear Mode
