require a vba coding to merge cells when typing please

**jnawabjj** · 03-14-2019, 12:08 PM

hi,

if anybody can assist ill be grateful, I have a range of cells that I want to merge providing that cell have texts entered into them. exactly how a text box would auto fit to the text but same with cells in range. an expanding box but with the range of cells

the current code I had is not executing on selection of the cell.

please do help and advise


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Selection.Count = 1 Then
        If Not Intersect(Target, Range("E95")) Is Nothing Then
Sub Range_Merge_Across_False()
    Range("E95:L104").Merge
End Sub

**arthurbr** · 03-14-2019, 12:29 PM

Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

From the forum rules (link in the main menu above):

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

**jnawabjj** · 03-15-2019, 08:44 AM

if anybody could assist or point in the right direction, would be appreciated.

thanks

require a vba coding to merge cells when typing please

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

require a vba coding to merge cells when typing please

Re: Urgently require VBA to auto merge range of cells whilst text is entered

Re: require a vba coding to merge cells when typing please

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Auto populate sequential ID numbers based on any text entered into adjacent cells

Selecting range of cells whilst 'event selection procedure' runs in the background

VBA coding require for auto fill maximum location in blank cells

[SOLVED] Combining Contents of two cells whilst preserving text coloring

VBA code to change font color in range of cells when certain text is entered?

Lock Range of Cells After Text is Entered

[SOLVED] Require Data To Be Entered In Cell Unless Selecting Specific Cells

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions