Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Unclear on Looping Structures
Name:
RozB
Email (spam proof):
Email the originator of this post
Date:
Wednesday, February 25, 2004
Hits:
52
Discussion (Terms and Conditions):
I need help with this issue. How to Code: Find the cell value in a Mixed Reference Condition. Absolute Column : Relative Row and Relative Column : Absolute Row Copy and paste the result on a new or existing Worksheet. Need to write a macro which will find the cell.value equal to "yes" in a defined name_range, then locate and copy the cell.value in Column $A of the same Row, return to position and locate and copy the cell.value in the same Column and Row $10. (Will also need to paste the copied value in a new or existing worksheet and return to position for the NEXT "yes" cell.value Loop) Sub CheckSelectYes() Application.ScreenUpdating = False Sheets("Select").Range("selectLanguage_Area").Select For Each cell In Selection If cell.Value = "yes" Then 'Here is where the problem is! Next Application.ScreenUpdating = True End Sub Rozb �Losing Sleep in Everett�

Sponsored by the best FTP application on the internet: