i'm using UsedRange.Columns.Count on a download file to determine number of
columns (which will increase over time) and am using a lookup formula to pull
data out of that file and into a model.

i am copying that formula over the same number of columns in the model.
problem is, the recorded macro has fixed values which won't handle an
increase. what kind of code will allow my formula to be copied over a
changing number of columns? if this has been discussed previously please
reference those posts, thanks!