Hello,

I am sorry to always be asking about ranges... I keep getting an error that says "method range of worksheet object failed". It is the line that says Set Vbr... I am so confused because I have never had this problem before when dealing with ranges.

If anyone can help me out, I'd greatly appreciate that. Thanks!

Dim k, j, m, n As Integer
    Dim reticle As String
    Dim numberOfRows As Integer
    Dim Wg As Double
    Dim i As Integer
    Dim id As String
    Dim idss As Double
    Dim vbr As Range
   
    
    
    i = 1 'Vbr column
    k = 6 'id(A/um) column
    j = 2 'reticle number
    n = 2 'id column
    
       
  
   Set vbr = Range(i & "123", Range(i & rows.count).End(xlUp))