| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pass cell value as string to function
Rowan Drummond wrote in
: When you declare variables like this: Dim test1, test2, test3 As String only test3 is declared as a String. test1 and test2 will be assigned the DataType Variant. UpdateAll is looking for a variable with a string datatype. Change your decleration to dim test1 as string, test2 as string, test3 as string or Dim test1 as string dim test2 as string dim test3 as string Hope this helps Rowan Gah! Yes, that helps. fyb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pass string value to another form | Excel Programming | |||
| Pass multiple characters to a string variable | Excel Programming | |||
| TypeLib Information Problem? Pass a Function's parameter names as string for parsing? | Excel Programming | |||
| Pass string as Parameter in OpenText method | Excel Programming | |||
| Can we Pass String to FieldInfo Array to OpenText Method. | Excel Programming | |||
Threaded Mode
