Valid data for an Excel Cell RRS feed

  • Question

  • Hi All

    I am automating Excel via COM

    Is there any validation I can/should do on my pieces of data before passing them to Item of a Range object to place that data in an individual cell

    I'm trying avoid giving Excel any reason to raise an error at this point

    I appreciate cell accept pretty much anything

    At this stage I do not need to pass formulas so I guess I could simply check for '=' as the first character of the string and ignore it if it finds one

    Is there and excel specifications page that contains maximum sizes/ranges/limits on what excel can cope with

    Thanks in advance

    Friday, July 29, 2016 9:11 AM