Don't wrap OR bleed over

Posted on 2013-10-07
Medium Priority
Last Modified: 2013-10-07
How do I keep links from bleeding over to the next column?  I do not want them to wrap or to bleed over to the next column.
Question by:frugalmule
  • 2
LVL 93

Expert Comment

by:Patrick Matthews
ID: 39552982
Simply ensure that the next column is not empty.

A simple formula of ="" will do the trick.

Author Comment

ID: 39553039
By default?
LVL 93

Accepted Solution

Patrick Matthews earned 2000 total points
ID: 39553127
There is no default setting that will prevent a text value from bleeding over if the cell it is in is too narrow to contain it, word wrap is off, and the next cell over is empty.

You could do something like this, in the sheet module for the worksheet you need watched.  Any time you edit a cell in Col A, the corresponding cell in Col B gets the ="" formula.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim cel As Range
    If Not Intersect(Me.[a:a], Target) Is Nothing Then
        Application.EnableEvents = False
        For Each cel In Intersect(Me.[a:a], Target).Cells
            cel.Offset(0, 1).Formula = "="""""
        Application.EnableEvents = True
    End If
End Sub

Open in new window


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question