Excel VBA Code that References Custom Range within Formula

[acool]

Hi Everyone,

I am currently trying to create some lines of code that will enable me to create two custom ranges. For my first range, I would like to reference A3: Last Row in Column A and extend that to Column C from Worksheet "Full Data Pull". For my Second Range, I would like reference B3: To Last Row where column A ends on "Full Data Pull". After creating these two custom ranges, I would like to implement these custom ranges into my Take/Sort Formula provided below. Instead of 'data (2)R3C1:R285C15, I would like to substitute this with "Rng." Similarly, instead of using 'data(2)! R3C2:R285C2, I would like to use "Rng2." If anyone could please provide some insight into the best way to incorporate my custom ranges into my take/sort/Filter formula, that would be greatly appreciated. Thank YoUu!

 

[GlennUK]

What does Rng.Address(ReferenceStyle:=xlR1C1) give you? It should be the string that you can use in building that formula.