Strike-through an entire row.

MS EXCEL

    Sponsored Links

    Next

  • 1. open a file automatically which was created yesterday
    Hi, i have a macro which opens a file which is created automatically with a date in the filename. I can add the date to the filename but I want to open the file in a series of macros to be run every morning. I have tried using some examples from the disscussion board but no success yet. I want the filename updated with yesterday's date. The constant name of the file is Report15Probability whith the date yyyymmdd. I am about to try the LastMofifiedYesterday property but I am running out of options. Sorry for not posting the code but this is due to restrictions on e-mail Hope some one can help. Davie
  • 2. White Alice Communications System
    Hi All....... Please forgive the off-task, but I wanted to mention that I am an old White Alice Communications System Site Representative, and was wondering if there are any others here in the Excel Groups. If so, please contact me by email at XXXX@XXXXX.COM Tks Vaya con Dios, Chuck, CABGx3
  • 3. Skipping Blanks
    When I try to copy data and paste it without the blanks in between, I use the paste special and check on the "skip blanks" box. However it does not work. Does anyone know how to accomplish this, or why it is not working?
  • 4. Table on Data menu
    I am in a class that is using the 2003 Excel book, but I'm using 2007, and I'm having trouble finding the Table that used to be on the Data menu. I have to insert something in the column input cell. If anyone can direct me, it is greatly appreciated!
  • 5. "classic" yellow highlighter
    Sorry if this question has been asked before, but I haven't been able to find any definitive answer in the discussion groups. What I want to do is highlight some text, not all, inside a cell. The effect would be just like using a highlighter on paper. This is easily done in Word, but I can't find any way to do it in Excel. Any suggestions would be appreciated. BTW - using Excel 2003 w/ Windows XP SP2 Thanks

Strike-through an entire row.

Postby HoundofCullin » Wed, 21 Jan 2004 08:31:51 GMT

OK... I need to know if there is a way I can strike through the text on
a row by highlighting the row with the defunkt information and
activating a macro.

Let's see if I can give an example.


Say I'm entering data in, row by row... Each row's data is SIMILAR but
not the same. 
Now let's say that apon review I notice that one of the row is
incorrect.
I need to be able to highlight the row (Presumably by selecting the
corresponding number on the left hand side {1,2,3 etc}) then I need to
run a macro (that will eventually be tied to a button) and then be done
the macro would turn the text .RED  and then strike through the
information. Is that even possible? if so... can you help me?!


Thanks a ton, Josh


---
Message posted from  http://www.**--****.com/ 


Re: Strike-through an entire row.

Postby Earl Kiosterud » Wed, 21 Jan 2004 08:46:11 GMT

Josh,

You can select an entire row with Shift-Space too.  The following code will
make the entire row red (that the cell pointer is in).

Sub RedStrike()
    With Selection.EntireRow.Font
      .Strikethrough = True
      .ColorIndex = 3
      End With
End Sub

I did this by recording a macro, then taking out a bunch of stuff and
tweaking it a bit.  You may wish to assign a shortcut to run it quickly from
the keyboard.  Tools - Macro - Macros.  Select the macro, and click Options.
There's a place to put in a shortcut.  I used Shift-R.  It wound up
Ctrl-Shift-R.  The Excel shortcuts don't use Shift, AFAIK.

-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"HoundofCullin >" << XXXX@XXXXX.COM > wrote in





Similar Threads:

1.Error--"try selecting only entire rows, entire columns, or just groups of cells"

I've looked online for help and found the following.  I tried following the
directions, but it doesn't seem to do anything.  The original row shows 2
selected rows (even when I try to select only one to delete the other) and
when I follow these directions, it inserts 2 rows.  :

>  That command cannot be used with selections that contain entire rows or
> columns, and also other cells.
> Try selecting only entire rows, entire columns, or just groups of cells.
> CAUSE
> This behavior occurs when all of the following conditions are true:
> 
> €    You merge cells in a column or row. -and-
> 
> €    You select the entire column or row in which you merged cells. -and-
> 
> €    The column or row that you select contains a merged cell that extends
> over another column or row that you do not select. -and-
> 
> €    You click Columns or Rows on the Insert menu.
> RESOLUTION
> To resolve this behavior, select a single cell in the column or row in which
> you merged cells (not the entire column or row), and click Columns or Rows on
> the Insert menu. 


Michelle York
Literacy Coach (1-5)
Highland Park Central Elementary School
Topeka, Kansas

2.Row and Column Strikethrough

  Why are my Row and Column Headers shown with a Strikthrough each of the 
letters and numbers?
  I can email a screen shot in PDf if anyone would like to see.

Thansk,
Craig

3.remove rows that have any cells values strikethrough to a blank Sheet2

4.delete rows that have strike-through values in column A

5.Strikethrough cells B2 to E2 (a "row", in essence) when A2 has a c

Place this code in the "sheet" module that corresponds to the sheet you want 
to monitor.

Regards,
Bill


Private Sub Worksheet_Change(ByVal Target As Range)
    Dim strAddress                  As String
    Dim rngFormat                   As Range

    If (Target.Cells(1).Column = 1) Then
        strAddress = "B" & Trim$(Target.Cells(1).Row) & ":E" & 
Trim$(Target.Cells(1).Row)
        Set rngFormat = Target.Parent.Range(strAddress)
        
        If (Len(Target.Cells(1).Value) = 0) Then
            rngFormat.Font.Strikethrough = False
        ElseIf (Asc(Target.Cells(1) = 118)) Then   ' 118 is the ascii code 
for the sq rt symbol
            rngFormat.Font.Strikethrough = True
        End If
    
        Application.Calculate
    End If

End Sub



"StargateFanFromWork" wrote:

> The reason this is tricky is because all the other columns have all 3
> possible conditional formatting slots taken, so it seems one would need to
> use code for this.
> 
> I use the square root symbol (representing a checkmark) in a pulldown menu
> in column A.  So column A is either empty or it has this symbol.  When
> empty, nothing happens; but if user chooses this "checkmark" symbol, the
> cells in column B to E of that row should then have a strikethrough applied
> to the text in that row.  Also, where would one put the vb code to do this?
> I've searched the archives but so far no mention has been made on where this
> type of code to augment conditional formatting should go.
> 
> tia   :oD
> 
> 
> 

6. strikethrough row number

7. Row-Entire row changes color (and stays) selecting first entry

8. i want to highlight entire row when selecting a cell in that row



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 5 guest