1004 Autofill with row counter variables

[puskacpj]

The report is based on the number of tickets that owners have and are aged. I copy the owner list and remove duplicates and I count and save to: tot_ownnew_cnt. There are 5 different sections on each sheet based on the severity group. (severity 1,2,3,4,5) I age owner tickets in each group. I use tot_ownnew_row for where I'm at and when I do the autofill, I want it to take the current info in columns B:I and fill to the last owner entry. Basically it is:
tot_ownnew_row = 103
tot_ownnew_cnt = 197

Range("B103:I103").Select
Selection.AutoFill Destination:=Range("B103:I197"), Type:=xlFillDefault
Range("B103:I197").Select
That would be: "B" & tot_ownnew_row &":I" & tot_ownnew_cnt &""


Selection.AutoFill Destination:=Range("B" & tot_ownnew_row & ":I" & tot_ownnew_cnt & ""), Type:=xlFillDefault

 

[GlennUK]

You've shown your new code using the variables. But what selection does your code make prior to that line of code?

In fact you don't need to make a selection ... refer to the range directly, like:

Range("B" & tot_ownnew_row & ":I" & tot_ownnew_row).AutoFill Destination:=Range("B" & tot_ownnew_row & ":I" & tot_ownnew_cnt), Type:=xlFillDefault

 

[puskacpj]

Thank you for helping. This is what I have. It is giving the 1004 error:
AutoFill metod of Range class failed

Range("B" & tot_ownew_row & "I" & tot_ownnew_row & "").Select

tot_ownnew_cnt = tot_ownnew_cnt + tot_ownnew_cnt

Selection.AutoFill Destination:=Range("B" & tot_ownnew_row & ":I" & tot_ownnew_cnt & ""), Type:=xlFillDefault


tot_ownnew_row is the first row in that Severity Aging section.
tot_ownnew_cnt is the last row to autofill. This is making my head hurt.

 

[GlennUK]

Your variables have various spellings. Use Option Explicit and DIM your variables to prevent such spelling mistakes.