I am writing some Excel VBA code to go along with the MDS add-in so our users will have an easier time sorting, filtering, and publishing data.
The code I wrote populates some cells with data from another sheet whenever the user makes a change in a certain column. The code is working and populating the correct cells with the right data; but, when I press publish the newly populated cells do not publish.
I have noticed that the cells do not change color when they are automatically populated by the procedure. Is there a procedure, method, or something that I can use on these cells to make MDS see that there has been a change so that they will be published when the publish button is pressed?
The code I am using to populate the cells looks like this:
Cells(RowNum, ColNum).Offset(0, 5) = Category
Cells(RowNum, ColNum).Offset(0, 7) = Style