A method to save multiple styles in a global variable with name then to apply A style (from many previously stored styles) when writing a value. This would be a huge time saver. Of course this would have to include borders, colors from what ever the other things that are held in a style. Technically this is highly possible with storing styles, but if it applied a value and style at the same time, It could save hundreds of lines of code, because each cell should have at least an value in it even if it is storing a 0 length string balance to a cell. If there was also an optional method for a small enumerated override, we would have many more possibilities too. Also having an overall default style when starting up a sheet would be great too so that would cut down on the amount of other possible cases of styles. Instead of this: WorkSheet.Cells("A" & 2.ToString).Value = "Start string" & WithVarable How about this: WorkSheet.Cells("A" & 2.ToString).Value("Start string" & WithVarable, StoredStyle) Scenario is to have 5 or 6 styles saved globally with things like shading, borders, font heights, and alignment to name a few. Then when writing a value which could also be a null value, to a cell would save so much time and incredibly easy to do. This would open more doors for writing shading in line cell and blank in one right beside it very easy.
Comment (1)