de setembro de 2013 00:55
*Para:* excel-macros@googlegroups.com
*Assunto:* Re: $$Excel-Macros$$ Delete Line
** **
Sub deleteline()
Dim rngRange As Range
Dim rngCell As Range
Dim rngUnion As Range
Dim strvalue As String
Dim
em: domingo, 29 de setembro de 2013 00:55
Para: excel-macros@googlegroups.com
Assunto: Re: $$Excel-Macros$$ Delete Line
Sub deleteline()
Dim rngRange As Range
Dim rngCell As Range
Dim rngUnion As Range
Dim strvalue As String
Dim intcolumn As Integer
Hi,
I need a help from the group. I nedd to do a macro that delet a line in
the sheet if is not the value I´m looking for. For example in the sheet
above, I want only to keep the lines with “k” in the first cell. All the
other lines I need to delete, so the first line, the third and
Sub deleteline()
Dim rngRange As Range
Dim rngCell As Range
Dim rngUnion As Range
Dim strvalue As String
Dim intcolumn As Integer
Set rngRange = ThisWorkbook.Worksheets(1).UsedRange
intcolumn = InputBox(Please enter the Column Number,where you have
that value
So I have a file where a task/person responsible etc. is listed
When the task is completed, I would like to enter yes and upon this
text entry, the file would delete that line and add it to another tab
with other completed tasks.
Task Person Complete?
RFP Jane Doe
--