Referencing a cell in other worksheet that is using autofit row he

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

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

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

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