Thread
:
Inser row with the format from the row above.
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Inser row with the format from the row above.
unprotect
code
protect
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"pgarcia" wrote in message
...
Forgot to add, the sheet is password proteced.
Thanks
"pgarcia" wrote:
I have the following code but needs some help tricking it.
Private Sub CommandButton1_Click()
ActualRow = Selection.Row
Cells(ActualRow + 1, 1).EntireRow.Insert
Range(Cells(ActualRow, 1), Cells(ActualRow, 3)).Copy _
Destination:=Cells(ActualRow + 1, 1)
End Sub
1. I need to start in cell D34
2. Copy the format in D34 to new row
Thanks
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett