Merge data with blank cells below

C

cadetgideon

New Member
Joined
Dec 15, 2011
Messages
20
I am starting a new thread for my question since the thread i replied on is 2 years old. I have a TV guide i am trying to format for printing so merging cells is what i need to do. I need a macro to search through 7 tabs in my spreadsheet (a tab for each day of the week). It needs to search through multiple columns (each column is a channel). I need a macro that will go down the data and when a cell has a tv show title in it, the macro merges all blank cells below the cell with the title in it. This will create a large block that will match the times i have in column A on the left. I have absolutly no experience in VB so i dont even have a start to the code and cant find an example of wha ti need anywhere online.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
I need the macro to merge all blank cells below a cell that has a tv show title in it. Then when it gets to a cell with another tv show title in it, the macro merges all blank cells below that one. Column A has all the times in it so the macro can stop running when there is nothing else in column A. also, it would stop when there is no more info in a columns row 1 because that woul dbe the last channel. I would like it to run on all tabs in my workbook. Please let me know if this is possible.
 
Sort by date Sort by votes
-7:00 GMT AFN|prime Pacific
0:00 The Oprah Winfrey Show (TV-PG ): Episode 195
0:15
0:30
0:40
1:00 Wheel of Fortune (TV-G ): Episode 194
1:05


Here is an example of cells. Column A will have the programming times which change so there are different number of time slots each week. Column B all the way to M or N will have different channels. (the channels change so different number of columns).

I want the macro to merge blank cells below the shows into one cell so when i show borders it just has the one show in a large box. the show title will be centered in the column but left at the top of the cell. Oprah would be merged with the three blank cells below. Wheel of fortune would be merged with the one blank cell below it. Please let me know if anyone can help with this.

if there is a better way for me to show you an example please let me know. I cant figure out how to post a screen shot. I am on a .mil computer so several of the sites are blocked.
 
Upvote 0
Maybe ...
Code: 
Sub x()
    Dim wks         As Worksheet
 
    On Error Resume Next
    For Each wks In Worksheets
        With wks.UsedRange
            .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
            .Value = .Value
        End With
    Next wks
End Sub
 
Upvote 0
Try this.. it will work for n number of Channels (columns) and in all Worksheets of your file.

Code: 
Sub tvshowtimes()
For Sh = 1 To Sheets.Count
If Sheets(Sh).UsedRange.Address = "$A$1" And Sheets(Sh).Range("A1") = "" Then
'if any sheet is blank, skip that sheet
GoTo 1
End If
    lstrw = Sheets(Sh).Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    lstcl = Sheets(Sh).Cells.Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
    For j = 2 To lstcl
    rwstart = 1
        For i = 1 To lstrw
            If Sheets(Sh).Cells(i, j) <> "" Then
                If i > rwstart Then
                    With Sheets(Sh).Range(Chr(j + 64) & rwstart & ":" & (Chr(j + 64) & i - 1))
                        .HorizontalAlignment = xlCenter
                        .VerticalAlignment = xlTop
                        .ReadingOrder = xlContext
                        .MergeCells = True
                    End With
                End If
            rwstart = i
            End If
        Next i
        With Sheets(Sh).Range(Chr(j + 64) & rwstart & ":" & (Chr(j + 64) & i - 1))
            .HorizontalAlignment = xlCenter
            .VerticalAlignment = xlTop
            .ReadingOrder = xlContext
            .MergeCells = True
        End With
    Next j
1:
Next Sh
End Sub

Let me know if this need any change..
 
Upvote 0
shg said:
Maybe ...
Code: 
Sub x()
    Dim wks         As Worksheet
 
    On Error Resume Next
    For Each wks In Worksheets
        With wks.UsedRange
            .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
            .Value = .Value
        End With
    Next wks
End Sub
Click to expand...
Now that is code I like! ;)
 
Upvote 0
Rick Rothstein said:
Now that is code I like! ;)
Click to expand...


That code doesn't give the expected results..

cadetgideon is looking for this..

<TABLE style="WIDTH: 739pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=986 border=0><COLGROUP><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 227pt; mso-width-source: userset; mso-width-alt: 11081" span=3 width=303><TBODY><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; WIDTH: 58pt; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right width=77 height=22>0:00</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; WIDTH: 227pt; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" width=303 rowSpan=4>The Oprah Winfrey Show (TV-PG ): Episode 195</TD><TD class=xl67 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; WIDTH: 227pt; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" width=303></TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; WIDTH: 227pt; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" width=303 rowSpan=3></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:15</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:30</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:40</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=4>The Oprah Winfrey Show (TV-PG ): Episode 195</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>1:00</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>1:05</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=4>The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:00</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=4>The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:15</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=9>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:30</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:40</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=5>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>1:00</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>1:05</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:00</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=4>The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:15</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:30</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:40</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>1:00</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=4>The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>1:05</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:00</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=4>The Oprah Winfrey Show (TV-PG ): Episode 195</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=4>The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:15</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:30</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=4>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>0:40</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>1:00</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; BACKGROUND-COLOR: #fde9d9" rowSpan=2>Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: #3f3f3f 2pt double; BORDER-TOP: #3f3f3f; BORDER-LEFT: #3f3f3f 2pt double; BORDER-BOTTOM: #3f3f3f 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: #fde9d9" align=right height=22>1:05</TD></TR></TBODY></TABLE>

But shg's code fills up the blank cells like:..

<TABLE style="WIDTH: 338pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=450 border=0><COLGROUP><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width=92><COL style="WIDTH: 269pt; mso-width-source: userset; mso-width-alt: 13092" width=358><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 69pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right width=92 height=20>0:00</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 269pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=358>The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>0:15</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>0:30</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>0:40</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">The Oprah Winfrey Show (TV-PG ): Episode 195</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>1:00</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Wheel of Fortune (TV-G ): Episode 194</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>1:05</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Wheel of Fortune (TV-G ): Episode 194</TD></TR></TBODY></TABLE>
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Mail Merge 12:00:00 AM for cells with a formula that is supposed to be blank
Replies
7
Views
85
etaf
etaf
D
  • Solved
Merge and Center one Row
Replies
3
Views
180
Kaper
Kaper
T
  • Solved
Merged cells - identifying and then unmerge
Replies
2
Views
195
TheWennerWoman
T
A
  • Locked
  • Question Question
Severe Amateur needs code to pull data from multiple sheets into one master
Replies
1
Views
130
Peter_SSs
Peter_SSs
C
  • Question Question
How can I assign a macro to a cell with text in it and do this with 2+ cells each referencing their own macro?
Replies
7
Views
203
ceroberts75
C

Forum statistics

Threads
1,226,771
Messages
6,192,917
Members
453,766
Latest member
Gskier

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top