I wrote a code to convert text input files to a structured excel sheet as defined cells and tables
I had created several cells and assigned values through the text input, using csng to convert text to values.
Then I formatted a set of values into a listobject table within the VBA. However, upon the creation of the table, I noticed that some values on cells above the table that is not part of the table changed automatically.
The figure below show the values before the table is converted to a listobject
And the figure below shows the data when the table in cell range("B14:F50") is added to the listobject using the following VBA code
ws2.ListObjects.Add(xlSrcRange, ws2.Range(.Offset(0, 0), _
.End(xlToRight).End(xlDown)), , xlYes).Name = "CarRating"
Noticed how the values in cells B7:B8 changed. Incidentally, the values in B6 and B10 did not change even though all four values were created using the same csng function.
Hoping you can help explain why the numbers change just from creating a listobject.
Thanks
I had created several cells and assigned values through the text input, using csng to convert text to values.
Then I formatted a set of values into a listobject table within the VBA. However, upon the creation of the table, I noticed that some values on cells above the table that is not part of the table changed automatically.
The figure below show the values before the table is converted to a listobject
And the figure below shows the data when the table in cell range("B14:F50") is added to the listobject using the following VBA code
ws2.ListObjects.Add(xlSrcRange, ws2.Range(.Offset(0, 0), _
.End(xlToRight).End(xlDown)), , xlYes).Name = "CarRating"
Noticed how the values in cells B7:B8 changed. Incidentally, the values in B6 and B10 did not change even though all four values were created using the same csng function.
Hoping you can help explain why the numbers change just from creating a listobject.
Thanks