Re: VBA Error "Type Mismatch"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Cutting can cause formulas to produce an error(s) - if that is what you are
asking.

--
Regards,
Tom Ogilvy


<steve@xxxxxxxxxx> wrote in message
news:1150807222.742750.200190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Tom

I was indeed harvesting some of the info from a spreadsheet, but there
are no signs of error values on the spreadsheet itself.

One unusual event occurred. I made a mistake on the spreadsheet and
instead of cutting and pasting in standard fashion I moved the cell
values using the cursor. Could this have generated a behind the scenes
error?


Stephen Allen
ACBA


Tom Ogilvy wrote:
Any possibility you were harvesting an error value off a spreadsheet and
expecting a string?

--
Regards,
Tom Ogilvy


"steve@xxxxxxxxxx" wrote:

I have a piece code containing a variable

Dim CopyFullName as Variant

The purpose of the variable is to generate a full file name from a
variety of sources - most of which are string based but some times the
string is converted from another source hence the data type variant.
These are concatenated together to generate the final variable.

After several 10s of thousands of iterations the programme declared a
run time error of "Type Mismatch" for a particular string (and no
other
- so far). More over this is a batch process - all the other variables
in the same batch were created through the identical pathway and did
not generate the run time error.

Any thoughts on how or why vba should generate a type mis-match for a
particular string where the data type declaration is variant?


Stephen Allen
ACBA





.

Relevant Pages

  • Re: VBA Error "Type Mismatch"
    ... I was indeed harvesting some of the info from a spreadsheet, ... variety of sources - most of which are string based but some times the ... string is converted from another source hence the data type variant. ... not generate the run time error. ...
    (microsoft.public.excel.programming)
  • VBA Error "Type Mismatch"
    ... Dim CopyFullName as Variant ... string is converted from another source hence the data type variant. ... not generate the run time error. ...
    (microsoft.public.excel.programming)
  • Re: New to Classes, please help.
    ... David Lozzi ... > A class is a data type, just as an integer or a string. ... >>> example, username dlozzi, password fun. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: [1/1][PATCH] nproc v2: netlink access to /proc information
    ... Nproc, on the other hand, uses field IDs to identify information. ... Data type ID ... For strings, the string itself is prepended with a u32 indicating the ... the kernel suggests "VmShared" as a label, "%8u" for formatting, ...
    (Linux-Kernel)
  • Re: Custom function to search a string of text for certain values
    ... Function rcmnf(eqn As String) ... Tom Ogilvy wrote: ... worksheetfunction are available through application. ... functions having an array would need to be array entered to function. ...
    (microsoft.public.excel.programming)