Hello, I am wanting one macro to do the following steps:
1. Wrap text when cell is selected (this will be in column C all the time)
2. Adjust the height of cell to fit the wrap text (this will be in column C all the time)
3. When column C has something in it, in column A I want to place number 1.
Note...Currently in A1 I have the following formula....=MAX(A3:A850)
I want it so that when something is in Column C, the text gets wrapped, the cell is adjusted to height correctly, and the number based on A1 is put in correctly in A column.
Hope this makes sense. Thank you.
1. Wrap text when cell is selected (this will be in column C all the time)
2. Adjust the height of cell to fit the wrap text (this will be in column C all the time)
3. When column C has something in it, in column A I want to place number 1.
Note...Currently in A1 I have the following formula....=MAX(A3:A850)
I want it so that when something is in Column C, the text gets wrapped, the cell is adjusted to height correctly, and the number based on A1 is put in correctly in A column.
Hope this makes sense. Thank you.
