阅读背景:

如果一个值已被输入到同一行中的另一个单元格,则Excel宏将更改单元对齐、边框和包装文本。

来源:互联网 

I am trying to create an excel macro which updates the cell alignment, wrap text and borders of cells in each row if a value is entered into one cell within that specific row. For example, if a value is entered into cell A1, then I want the macro to update the wrap text, cell alignment and borders of cells A1:O1. Unfortunately, applying conditional formating to each row within the spreadsheet is rather cumbersome and only will handle updating the cell borders, so I think that a macro that can update all 3 cell formatting elements and dynamically searches the entire worksheet, would be best.I am trying to create an excel macro which upda




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: