Hello,
I want to write a macro where on inserting a new row in the active worksheet, the newly inserted row will become yellow in color. But I dont know how to do this. kindly help
Thanks
Insert Macro
Hot Topic
- subscript out of range
- question about word automation(how to insert header)
- Extracting an embedded document within a cell in a table in a Word document
- Excel COMBOBOX data sources
- VBA registry interface
- Returning the Server Referral By DFS link
- sending emails from MS Word with variable subject line
- send excel 2007 workbook using cdo?
- How to convert excel file to .DAT file?
- Projects, objects & modules
Microsoft ISV
- Web Page Components
- Business Scorecard Manager to Sharepoint deployment
- Password question
- Integer inside a MsgBox? (VBA Access 2000)
- Using visual basic and DDE ( dynamic Data exhcange) to syncronize Media Player with Excel
- Dllokup help
- How do I open CSV using Excel without deleting leading zeros?
- Excel Macro that finds empty cells and unlocks the cell how to???
- MS Access User Defined Permissions
- automatically saving word doc versions every 5mins
Insert Macro
Cryo75
Hi
In order to run your macro it needs to be triggered by an event. I don't think that there is an event generated by inserting a row.
Poma
There is no event handler for inserting a row.
However, you can add a row and turn the background color to yellow with VBA.
For example
Sub X()
Dim rngCurrent As Range
Set rngCurrent = ActiveCell
rngCurrent.Insert (xlShiftDown)
With ActiveSheet.Rows(rngCurrent.Row & ":" & rngCurrent.Row).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End Sub