VBA Code Behaving Badly!

R

rozb

I need help with this issue

How to Code
1. Find the cell value in a Mixed Reference Condition
Absolute Column : Relative Row and Relative Column : Absolute Ro
2. 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 = Fals
Sheets("Select").Range("selectLanguage_Area").Selec
For Each cell In Selectio
If cell.Value = "yes" Then 'Here is where the problem is
Nex
Application.ScreenUpdating = Tru
End Su

Rozb “Losing Sleep in Everettâ€
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFill without sequential order 1
Time issues in code 6
Help with this macro 6
Run Time Error 13: Type Mismatch 1
fill several sheets with data from other workbooks matching criter 0
Autofiltering & copying results to new worksheet - custom message box 0
Autofilter with criteria from userform 2
Autofilter & copy results to new worksheet 0

Top