Trouble w/ Autofill in recorded macro

[throwaway321]

Hello,

I've recorded a code, a portion of my record utilizes the autofill function when I double click the '+' in the bottom right hand corner of the cell. This autofills the data all the way until the left adjacent data ends. The problem is the the recorded macro utilizes a specific number of rows to autofill, rather than dynamically changing the autofill to fit the data.

Here's the portion of the code, of which occurs multiple times through my recorded macro:

Please Login or Register  to view this content.

Notice how this will only autofill through E108, but I want it to change less/more depending on the adjacent data to the left. Any help will be greatly appreciated

[dominicb]

Good afternoon throwaway321

This question seems remarkably similar to this question which has a working answer that you haven't bothered to respond to.

If this question is different in some way (and I don't think it is, but I shall leave it unlocked for now) then you might like to offer a word of thanks to YasserKhalil for his time in answering your last question and explain why it didn't work out for you.

DominicB

[Mumps1]

Try:

Please Login or Register  to view this content.

This will adjust based on the last row with data in column D.

[throwaway321]

Oh I hadn't noticed I got a response on the thread; I figured I'd update w/ a new more specific post. I will go test his response and add reputation accordingly.

thank you!

[throwaway321]

Thanks Mumps1! I believe your solution has worked. However now as i'm skimming through my code, I believe a have another similar problem but this time It's with the remove duplicate function.

The code I have now:

Please Login or Register  to view this content.

Again this is another problem w/ my recording, as it only records a specific cell rather than a dynamic range.Starting in column P, the data is sorted in a way that blanks come first, followed by the data. What i'm trying to simulate is Ctrl+Down in column P to go the first cell w/ data after the blanks, then Ctrl Shift Left and Ctrl Shift Down to select all the data from that point on, then finally remove duplicates.

Thanks again for your help

[Mumps1]

Try:

Please Login or Register  to view this content.

[throwaway321]

Does it matter where I enter this into my code?

[Mumps1]

It depends on what the rest of you code is doing. The macro finds the first and last rows with data in column P and then uses those cells to define the range on which to remove the duplicates based on column P.