Referencing a cell in other worksheet that is using autofit row he
in [Functions]
|
Prev: How do I write a formula in excel where 1 = .05 and 2 = .75 etc.
Next: I want a footnote number (small number) at end of sentence?
From: Bermi Girl on 5 May 2010 12:24 HELP! Greetings from Bermuda! I have referenced a cell in another worksheet that is using autofit row height. I want the cell that I am pulling the data into to automatically autofit row height also. Even though I have both cells in the two different worksheets designated to autofit, the cell that I am pulling the data into is still only showing the top line of text in the cell. I then have to manually set autofit again in order for it to take. Why is that cell height not automatically autofitting if both cells are designated to do so? I hope that wasn't too confusing :) -- Bermi Girl
From: Bob Umlas, Excel MVP on 5 May 2010 15:26
Right-click the sheet tab, select View Code, enter this: Private Sub Worksheet_Change(ByVal Target As Range) Rows(Target.Row).AutoFit End Sub "Bermi Girl" wrote: > HELP! Greetings from Bermuda! > > I have referenced a cell in another worksheet that is using autofit row > height. I want the cell that I am pulling the data into to automatically > autofit row height also. Even though I have both cells in the two different > worksheets designated to autofit, the cell that I am pulling the data into is > still only showing the top line of text in the cell. I then have to manually > set autofit again in order for it to take. Why is that cell height not > automatically autofitting if both cells are designated to do so? > > I hope that wasn't too confusing :) > -- > Bermi Girl |