Autofill multiple formulas in columns down to the last row with data in it in column B - ignores column B entries

[armchairandy]

Hi

I have different formulas in 1106 columns relating to the 1st row (Column B)
There are up to 500 rows where data can be put in. This can lead to a lot of formulas, as I have up to 20 sheets of this.
The 500 rows are not always used, and I do not want unused formulas in the sheets
this is an automatic worksheet used by different users & so I need to automate the results, and not just tell people to darg to the bottom.

So...........

In column B, if there are 10 entries B17 to B26 - I need the formulas autofilled along J17 to AQU17 down to Row 26

I used the below formula, but when I ran it, the macro autofilled past row 26

Range("J17").Select
Range("J17:AQU17").AutoFill Destination:=Range("J17:AQU" & Worksheets("Test").Cells(Rows.Count, "B").End(xlUp).Row)

How do I make it stop at row 26??

Many thanks in advance

 

[armchairandy]

Mark58

Sorry for the delay, I ran the #4 macro & it came up 26 - I then ran the code I have been using , and it works!. Many thanks for your help, but I still do not know why I was having the problem in the first place.

Andrew

 

[MARK858]

Mark58

Sorry for the delay, I ran the #4 macro & it came up 26 - I then ran the code I have been using , and it works!. Many thanks for your help, but I still do not know why I was having the problem in the first place.

Andrew

Why do you not understand? You had data in a cell further down column B so the code was working as it should and finding the last cell in the column with data.