VB for Auto-Fill

[adgjqetuo]

Can someone help me tweak this code? It's telling me I need an object?

I need it to autofill just as if you selected range A1 and A2 and double clicked that little square on the bottom right hand side of the cell (so it stopps auto-filling at the last active cell in B)

Please Login or Register  to view this content.

[JBeaucaire]

Maybe this:

Please Login or Register  to view this content.

Since the one above overlaps the next section (which is what your original macro seemed to do), this version does NOT do that:

Please Login or Register  to view this content.

[Kenneth Hobson]

You probably need to explain what you mean by last active row in column B. When you use Select, you have changed the active cell. Select is seldom needed.

Try a manual fill and you will see the limitations of fill. Trying to fill a range that is not legal will result in an error. Comment the line above and uncomment the line below to see this error.

Please Login or Register  to view this content.

[adgjqetuo]

Thanks for the responses!

JBeaucaire: Yours worked but it just auto-fills down 60,000+ Cells - I need it to stop at the last active cell in column B (Just like if you double clicked that little square)

Kenneth: I tried your code, and couldn't get it to work.

[JBeaucaire]

Which column can be evaluated (examined) to determine the last row? Column B, for instance? You haven't posted a sheet so we're working blind here.

In the red line of code here, change the column listed (blue) to point to the column where data exists already and can be used to spot the last row to copy down to:

Please Login or Register  to view this content.

[adgjqetuo]

Works prefect!

Thanks!

And yes it was column B it needs to look at - sorry for the confusion!