+ Reply to Thread
Results 1 to 2 of 2

Row Height with Links

  1. #1
    Registered User
    Join Date
    07-29-2008
    Location
    charlotte
    Posts
    5

    Row Height with Links

    Using 2003, I am linking cell text from one sheet to another with the =PageName!CellNumber formula. I have the receiving page's row-height set to AutoFit, but when I enter text in the sending cell the receiving cell does not change size. I have to go to the receiving page and do the AutoFit fuction after entering in text on the sending page, which is a drag.
    Anyone know a fix so that the receiving cell in a link will really AutoFit to match the incomming text?

    Thanks

  2. #2
    Registered User
    Join Date
    07-29-2008
    Location
    charlotte
    Posts
    5

    Re:

    Nevermind, I thought I'd have to use the Worksheet_Change thingy but it responded to Calculate so yipeeee

    Private Sub Worksheet_Calculate()
    rows("15:200").AutoFit
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1