Hi Experts using Excel 213
i have the following VBA code which to a certain extent works kind of fine....
I am trying to populate a formula is cell B8 down based on the number of entries in column B2 onwards sheet "Unique List" into B8 and fill down...
so if we have a count of 83 in B2:B85 then autofill said formula in cell B8 (inc B8) 83 times..
Dim Rng As Long, Rng1 As Range
Application.ScreenUpdating = False
Rng = Sheets("Unique List").Range("B" & Rows.Count).End(xlUp).Row ' the range of entries
With Sheets("Broker Level")
.Range("B8:B" & Rng).FillDown ' the range where the formula is in the first cell
Application.ScreenUpdating = True