VBA code to create vlookup formula in range

[RoccoM]

Guys:
I have to create a vlookup for a range of cells. I have included an example below.
Here is my problem. How do I account for the formula when I do not know how many rows there will be in my range?
I already created a variable to store my row count, not sure on the rest.
Example: here is my current lookup formula that I created manually. ( obviously I know the range): =VLOOKUP(AE2,$AC$2:$AD$64828,2,FALSE

I copied my data into the same sheet so I can count the rows and store it into a variable. I just need help with using variable in my lookup formula; or is there an easier way?

Example data:
[TABLE="width: 839"]
<tbody>[TR]
[TD]RCD:TYPE[/TD]
[TD]RCD:FUNCTION[/TD]
[TD]Create From[/TD]
[TD]Lookup: Function Field[/TD]
[/TR]
[TR]
[TD]3C16942A[/TD]
[TD]SWITCH[/TD]
[TD]BLANK-PNL-19INCH-2[/TD]
[TD]CABINET_SUPPLY[/TD]
[/TR]
[TR]
[TD]3C17111[/TD]
[TD]ETH_SWITCHMODULE[/TD]
[TD]BLANK-PNL-19INCH-2[/TD]
[TD]CABINET_SUPPLY[/TD]
[/TR]
[TR]
[TD]3C17121[/TD]
[TD]ETH_SWITCHMODULE[/TD]
[TD]BLANK-PNL-19INCH-2[/TD]
[TD]CABINET_SUPPLY[/TD]
[/TR]
[TR]
[TD]3C17131[/TD]
[TD]ETH_SWITCHMODULE[/TD]
[TD]BLANK-PNL-19INCH-2[/TD]
[TD]CABINET_SUPPLY[/TD]
[/TR]
[TR]
[TD]3C17203[/TD]
[TD]SWITCH[/TD]
[TD]BLANK-PNL-19INCH-1[/TD]
[TD]CABINET_SUPPLY[/TD]
[/TR]
[TR]
[TD]3C17203[/TD]
[TD]SWITCH[/TD]
[TD]BLANK-PNL-19INCH-1[/TD]
[TD]CABINET_SUPPLY[/TD]
[/TR]
</tbody>[/TABLE]


Thank you,
Rocco

 

[Fluff]

How about

Sub RoccoM()
   Dim UsdRws As Long
   UsdRws = Range("AE" & Rows.Count).End(xlUp).Row
   Range("AG2:AG" & UsdRws).Formula = "=vlookup(AE2,$AC$2:$AD$" & UsdRws & ",2,0)"
End Sub

 

[RoccoM]

Thank you for the reply. This worked out nicely from me.
Rocco

 

[Fluff]

You're welcome & thanks for the feedback