Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FIND method , versus FOR EACH ...
A good day
I want to use FIND method instead my old FOR EACH method in my code , I think (and I have read) it will work faster . Actually , my code look so : ...... With FromWks1 Set myRng1 = .Range("AT20:BW20") End With ......... For Each myCell In myRng1.Cells If myCell.Value = True Then With FromWks1 .Cells(myCell.Row, myCell.Column).AutoFill _ Destination:=.Range(.Cells(myCell.Row, myCell.Column), .Cells(44, myCell.Column)) .Range("A1:N1").Copy .Range(.Cells("1", myCell.Column), .Cells("14", myCell.Column)).PasteSpecial , _ Paste:=xlPasteValues, _ Transpose:=True ........... another actions ... End With End If Next myCell Please very much to provide me this code , which shall use FIND method instead actually method I use ; I need FIND to look only in my range ( myRng1 = .Range("AT20:BW20") ). Many thanks in advance ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xls vba find method to find row that contains the current date | Excel Programming | |||
SUMPRODUCT search versus other method | Excel Discussion (Misc queries) | |||
date find using find method | Excel Programming | |||
Using variables to make a date and using find method to find that. | Excel Programming | |||
XLA versus Reference versus Nothing | Excel Programming |