Row number as a variable in cell references

[ChristineJ]

This is a short excerpt of code that relates to row 16. I need to repeat the same thing for other rows. The column letters will not change.
Is it possible to make the "16" throughout the code a variable so I can call the Review macro and enter in the row number?

Sub Review()
Range("P16").ClearComments
Call Condo("P16", "CC16")

Range("P16").Offset(0, 3).Formula = "=FORMULATEXT(CF16)"

If Range("P16").Value = Range("CF16").Value Then
    Range("P16").Offset(0, 1).Value = "  " & ChrW(&H2713)  
   
    If IsNumeric(Range("P16").Formula) = True Then
    Range("CG16").Value = "X"
    Range("CE16").Value = 2
    Else
    
    If IsNumeric(Right(Range("P16").Formula, Len(Range("P16").Formula) - 1)) Then
    
    Range("CG16").Value = "X" & vbCrLf & Range("CC16").Value
   Range("CE16").Value = 2
     Else
     
     If InStr(Range("P16").Formula, "$") > 0 Then
Range("CI16").Value = "NO"
End If

 

[mikerickson]

Use the Cells property rather than the Range property

use Cells(rowNumber, 16) instead of Range("P16") throughout (note P is the 16th column, the second argument is the column reference, not a the row reference)

 

[ChristineJ]

Use the Cells property rather than the Range property

use Cells(rowNumber, 16) instead of Range("P16") throughout (note P is the 16th column, the second argument is the column reference, not a the row reference)

OK, I can do that and refer to all the column letters in the code by their numbers in the second argument.

How do I make "rowNumber" a variable when I call the Review macro?

In this case I want the row number to be 16 as well. But I also want to run the same code for other rows.

Thanks!

 

[mikerickson]

You could use it as an argument of the Sub.

 

[ChristineJ]

You could use it as an argument of the Sub.

I am pretty new to VBA. Would it be possible to provide an example? Thanks.

 

[ChristineJ]

You could use it as an argument of the Sub.

I got it, based on your suggestion - thanks!