04-29-2019 06:36 AM
I think it's something to do with inserting numeric values into the cell because assigning an alignment to the cell seems to work properly for the text headers and row labels. The code crashes as soon as it enters a numeric value into a cell and I then try to set the alignment.
I'm currently investigating formatting the numeric values as strings.
04-29-2019 12:06 PM
Yeah I previously mentioned was thinking maybe you could enclose Val() in CStr(). CStr(Val(....))
04-29-2019 02:16 PM
I've tried to use just Str() as well as CStr(), both by them selves and with Val() embedded in them as well. I continue to get the same error.
I'm still stumped. Its not a requirement for my program to have everything center aligned, but I would like for it to look nice. If it continues to be an issue, I may just have to abandon the effort...