EXCEL macro @ before formula?

ByJakob223519

The formula to be copied is:
=VLOOKUP(B3;Data!A1:C26;2;FALSE)*F3

The copied formula appears like this:
=@VLOOKUP($B4; Data!$A$1:$C$26; 2; FALSE)*F4

My VBA macro is:

Sub AddAndCopy()

Dim ValueFromColumn2 As Variant

ValueFromColumn2 = Cells(3, 2).Value

Rows(4).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

Cells(4, 2).Value = ValueFromColumn2

Cells(4, 5).Formula = "=$B$4"

Cells(4, 6).Value = Cells(3, 6).Value

Cells(4, 7).Formula = "=VLOOKUP($B4, Data!$A$1:$C$26, 2, FALSE)*F4"

End Sub

How do I get the line to be copied without @?

(1 votes)
Loading...

Similar Posts

Where can I set in WordPress that the date is not in the title/link of a new post: webseite.de/2023-17-04/blogtitel?

BythatzGoKat

Hello, I use WordPress for my blog and have the following problem. When I create a new post, it always includes the publication date in the top tab (the link), which I don't want. It will then look like this: webseite.de/ 2023-17-04 /blogtitel Where can I set the date to not be included? Thanks!

Subscribe
Notify of
1 Answer
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
daCypher
daCypher
1 year ago

You could have the @ standing there without any problems. This only tells Excel that the result should only fill one cell and not output a dynamic array.

The real problem is that you always have to use English spelling in the macros. In some cases, you’ve already done this because you exchanged the semi-colons for commas and wrote “False” instead of “False”. The same applies to the name of the function. Instead of SVerweis, you have to write VLookup. Then it stands in the cell without the @.

2