Hello. Noob here for macro vba.
I recorded a macro. Depending on the filter selection, the number of rows will change. I am attempting to get macros to base its selection on the number of rows regardless of having a defined range (as defined in the code below).

Currently this is the defined range it using but I would like to to base the selection on the cells with values from the top to the end. I tired selecting the entire column, but with the VLOOKUP formula, its taking a long time to process.

I like to change it on all three lines below. I am not sure if the "autofill" needs to change but if it does, please note that as well.

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC2,SETS.WY!R2C2:R4487C4,3,FALSE)"
Selection.AutoFill Destination:=Range("AP2:AP141967")
Range("AP2:AP141967").Select


Can someone assist?

Thank You

Hi

Are you trying to paste the formula for the entire range.

If you can briefly explain the requirements in would e useful

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

There are three columns (for columns B2,C2,D2) in the vlookup formula. The number of rows will vary depending on the filter of the active cell.

Looking at what the MACRO code, i believe it is here. I am not sure how to edit this so it selects on the range of data for those three columns for B2,C2,D2 and than an unknown number of rows.

Perhaps, I should try xlend function? but not sure how to insert this function with what MACRO has created the code for as follows:

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC2,SETS.WY!R2C2:R4487C4,3,FALSE)"