Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I found this bit of code on the internet.
Copy all the rows that have the value 1000 in column D and paste to Sheet2: Find_Range(1000, Columns("D"), xlFormulas, xlWhole).EntireRow.Copy Range("Sheet2!A1") This finds the value 1000 in column D. I want to be able to find a negative value in column D. Any clue? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xls vba find method to find row that contains the current date | Excel Programming | |||
Question using the excel find method in vba? | Excel Programming | |||
Question on Find method in vba | Excel Programming | |||
Using variables to make a date and using find method to find that. | Excel Programming | |||
Find Method question | Excel Programming |