Forum Discussion

Iron Contributor

Jul 22, 2022

Query related to VBA with formula

Hello Everyone, I want to apply VLOOKUP FUNCTION formula in filtered cells only with the help of VBA code. So, what should i write VBA code to give VLOOKUP FUNCTION and it should be dynamic ?? ...

VBA.xlsx20 KB

Macros and VBA

Excel

Iron Contributor

Jul 22, 2022

Sir, actually i am learning VBA.
Can you please full VBA code ? Please

cool2021

Iron Contributor

Jul 22, 2022

Excel Start with this Microsoft Support link about arrays: https://docs.microsoft.com/en-us/office/vba/language/concepts/getting-started/using-arrays

And then search from here within this site for ReDim Preserve as well.

This will get you started.

Thanks