Select Row determined by Variable

Good Morning,

Basically I'm trying to come up with a script that selects a row based on a cell value.

I have an If clause that finds each cell in a range that is colored purple and returns it's value to another cell on a separate sheet.

What i'm trying to do now is to select the 1st cell of each row and return it's value to another cell on a separate sheet.

ActiveCell isn't helping with this because since this macro is on a separate sheet, it won't look up the correct rows.

Can anyone help with this? Much appreciated!!!

Below is my code, the bolded part is the problematic portion:

For Each Cell In SrcRng1
If Cell.Interior.Color = RGB(112, 48, 160) Then
Job = Cell
Rows(Cell.row).Select
Selection.Cells(1, 1).Select

NextJob.Select
ActiveCell = Job
NextTech.Select
ActiveCell = Tech

Set NextJob = NextJob.Offset(1, 0)
Set NextTech = NextTech.Offset(1, 0)
End If
Next Cell

If you're using Excel 2003, I think you should be testing the ColorIndex property, not Color.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.