[EXCEL] Issues at the moment of inserting formula on excel table.

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

Unsolved

Author Summary

athalwolf506 is in Excel

Post Body

I am trying to insert a formula to a named table using VBA.

The formula uses a vlookup and takes as reference the value on the first column of each row, but for some reason it is giving me an error.

If I type directly de formula there is no issue but if I copy and paste the formula generated the Vlookup gives me an error saying that the syntax is not correct.

The formula is similar to this:

=IF(VLOOKUP([@Test],PR_Status_Table,4,FALSE)="N/A","N/A")

The part that gives a syntax error is [@Test].

Adding the full name of the table does not make any difference.

Upon executing the code it give a 1004 runtime error.

To assign the formula I am using a loop witht his code inside:

output_table.DataBodyRange(i, j).Formula =FArray(j - 1)

Where FArray contains the strings for different formulas.

Author

Account Strength

90%

Account Age

5 years

Verified Email

Yes

Verified Flair

Total Karma

4,317

Link Karma

1,280

Comment Karma

2,963

Profile updated: 5 days ago

Posts updated: 1 year ago

athalwolf506

Subreddit

r/vba

Post Details

Location

Excel

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 1 year ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/vba/comment...