Updating cells into vba
But there are significant changes to this part of the object model and I am only going to touch on the basic parts here. Name = _ "Table1" ' No go in 2003 Active Sheet. Table Style = "Table Style Light2" End Sub But the new stuff is right there already: Table Styles. Line Style = xl Dash End Sub This changes the linestyle of the bottom of your table. If you have any other workbook open, all tables with the same tablestyle appear in your changed style! Select ' Select only data of first column ' No go in 2003 . However, cells update when I hit F2 and then exit the cell. I have other worksheets open at the same time linked to the same sources that update correctly. The value of this property can be set to one of the standard colors: vb Black, vb Red, vb Green, vb Yellow, vb Blue, vb Magenta, vb Cyan, vb White or an integer value from 0 to 16,581,375.
To assist you with specifying the color of anything, the VBA is equipped with a function named RGB.
The value of this property can be set to an integer value from –90 to 90 degrees or to one of the following constants: xl Downward, xl Horizontal, xl Upward, xl Vertical.
Updating cells into vba comments