Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a Macro that will copy the rows that have a value < 0
How do I Create a Macro that will copy the rows that have a value < 0 and
paste them on anther worksheet |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a Macro that will copy the rows that have a value < 0
Try something like the following. Change the lines marked with <<
to the appropriate ranges. Dim DestRng As Range Dim Rng As Range Set DestRng = Worksheets("Sheet2").Range("A1") '<< For Each Rng In Range("A1:A10") '<< If Rng.Value < "" Then Rng.EntireRow.Copy Destination:=DestRng Set DestRng = DestRng(2, 1) End If Next Rng -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "wil4d" wrote in message ... How do I Create a Macro that will copy the rows that have a value < 0 and paste them on anther worksheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows in a macro in Excel | Excel Discussion (Misc queries) | |||
Macro to delete rows with same data | Excel Worksheet Functions | |||
copy rows meeting criteria to another worksheet | Excel Worksheet Functions | |||
copy exact values from RangeA to Range B which has extra rows | Excel Discussion (Misc queries) | |||
Copy Paste macro | Excel Discussion (Misc queries) |