Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
sorry for reposting this
But i need to be able to use the <= = commands with this code is this possible. Sub test() Dim i As Long, rng As Range, str As String str = "1st Quarter Quarter" Set rng = Worksheets("Sheet2").Rows(1) With Worksheets("Data") For i = 2 To .Cells(Rows.Count, 2).End(xlUp).Row If StrComp(.Cells(i, 2).Value, str) = 1 Then .Rows(i).Copy rng Set rng = rng.Offset(1) End If Next End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If statement to copy an entire row to other worksheet w/ in same b | Excel Worksheet Functions | |||
copy an entire row IF a statement is true | Excel Worksheet Functions | |||
Copying entire worksheets | Excel Discussion (Misc queries) | |||
Copying an Entire row using an IF Statement | Excel Programming | |||
Macro for copying entire raw | Excel Programming |