none
create excel file RRS feed

All replies

  • The reason for the green marker is because the data type is unknown.

    Depending on the type dictates the pattern used for NumberFormat property of a range or cells.

    See the following post which goes over the common types and note when they have xlYourRange that can be a range or a cell.


    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    StackOverFlow
    profile for Karen Payne on Stack Exchange

    Saturday, March 16, 2019 9:39 PM
    Moderator