• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA snippet to paste array formula

K

Karthik Thandapani

Member
Hi,

I am using array formula which is pulling data from another sheet. As it is taking more time to look up information & slowing the excel file, decided to perform that action with macro. Can anyone please help with a vba snippet to paste the following array formula into highlighted cells please. Much appreciated.

Thanks in advance for this help. Please see the attached file.

Regards,
Karthik
 

Attachments

  • vba+array formula.xlsx
    12 KB · Views: 5
Hi Karthik ,

First , why do you want this workbook to pull data from another workbook ?

Second , if you want others to reply , please explain your requirement instead of posting a formula ; otherwise , hopefully , the person who developed the formula will respond with a macro.

Narayan
 
Hi @NARAYANK991 ,
I have attached the updated file. The requirement is that, I need to pull the match, next match,......etc. For this I have a list of criteria and for that I have array formula running everywhere across 4k cells. This action is slowing down excel file & that's why I've decided to automate it via vba.

Can you help me with a vba snippet to paste array formula you see in cell"K8" and copy paste range("k8:m200")
That would be a great help. Thanks. Please see the attached file.
 
Hi Karthik ,

I am not able to see what updates have taken place between your initially uploaded file and the present one.

Secondly , when I said explain your requirement , I did not mean this :
vba snippet to paste array formula you see in cell"K8" and copy paste range("k8:m200")
Click to expand...
The whole purpose of resorting to VBA is not to reproduce a complicated formula in VBA ; it is to write code which will reproduce the functionality of the complicated formula , and hopefully the code will be written so that it is easy to understand and maintain.

If you can explain what the complicated formula is supposed to do , you might get a good solution ; in my opinion , VBA which just puts the same complicated formula in 4K cells is not VBA. Hopefully others will respond.

Narayan
 
You must log in or register to reply here.
Back
Top