Macro select a row depending on a value in a column

[Luke1690]

Hi Guys,

I want to select a row (A:L) depending on if there is a (1 or 2) in (j17:j87)

i have a conditional formatting set up to do this which highlights the row when a 1 or 2 is entered in j17:j87.
i want to only print the conditional formatting rule but i dont think this is an option with my version of excel....
so im going to set this code up and then add print selection to the code which should work the same.

please let me know if im going the correct way about this?

 

[DanteAmor]

I'm not sure if this is what you need.
With the following macro you will obtain a selection of rows as shown in the following image:

That is, it will select rows A to L if there is a 1 or a 2 in column J.

Sub select_rows_v2()
  Dim c As Range, rng As Range
  
  For Each c In Range("J17:J87")
    If c.Value = 1 Or c.Value = 2 Then _
      If rng Is Nothing Then Set rng = c.Offset(, -9).Resize(1, 12) Else Set rng = Union(rng, c.Offset(, -9).Resize(1, 12))
  Next
  If Not rng Is Nothing Then rng.Select
End Sub

Regards
Dante Amor

"The eyes only see what you want to see"
"Los ojos solamente ven lo que tú quieres ver"
Mental games​

 

[Luke1690]

legend mate, thanks for your help.