Referencing a cell in other worksheet that is using autofit ro
in [Functions]
|
Prev: Calculate next workday after adding calendar days to date in c
Next: How to clear all checkboxes on a form?
From: Bermi Girl on 5 May 2010 16:44 Thanks Bob. Do I type that in both worksheets or just the one receiving the information? I pasted it in just as you wrote it, but I don't see anything different. I will try again. Thanks -- Bermi Girl "Bob Umlas, Excel MVP" wrote: > 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
From: Dave Peterson on 5 May 2010 20:52
Check your later post. Bermi Girl wrote: > > Thanks Bob. Do I type that in both worksheets or just the one receiving the > information? I pasted it in just as you wrote it, but I don't see anything > different. I will try again. > > Thanks > -- > Bermi Girl > > "Bob Umlas, Excel MVP" wrote: > > > 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 -- Dave Peterson |