VBA error I cant figure out

**Peltz** · 07-20-2012, 08:02 AM

I cant get this to work. Could one of youy magicians take a look?

Please Login or Register  to view this content.

When i try to run this, i get Compile error expected: list or )

I trid to remove the IFERROR command, and it seems that its the MATCH command that is buggy.

Please Login or Register  to view this content.

Im so new to this, so trubbleshooting by my self is very hard

Thanks

**Andy Pope** · 07-20-2012, 08:36 AM

Please Login or Register  to view this content.

**Peltz** · 07-20-2012, 08:46 AM

Thanks a bunch!

**Peltz** · 07-20-2012, 08:48 AM

How would one program it so that it didnt show up in the formula at the worksheet, but programmed directly through VBA? The point is that later in the code I delete the value im lookin up, and therefor end up with nothing, instead of the original value.

**Andy Pope** · 07-20-2012, 08:50 AM

The use this after to replace formula with result of formula

Please Login or Register  to view this content.

**Peltz** · 07-20-2012, 09:15 AM

Hmm.. it show up as blank? Ill look into it..

BTW..

When running this:
Sheets("Utskrift").Range("J3:K4").Copy Destination:=Sheets("Utskrift").Range("J4:K4")

It includes the formats, is it posible to run it in a way that it only extracts the value of the cell?

**Andy Pope** · 07-20-2012, 09:17 AM

Your ranges are different sizes, is that just a typo?

Have a look at pastespecial or

Please Login or Register  to view this content.

**Peltz** · 07-20-2012, 09:18 AM

This is the full code

Yes It was A typo

Please Login or Register  to view this content.

The whole point is to track the history and reseting the for.

**Cutter** · 07-20-2012, 10:45 AM

@ Peltz

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules (Rule #3) require them so please keep that in mind and add them yourself whenever showing code in any of your future posts.
Thanks.

**Peltz** · 07-20-2012, 05:12 PM

Solved:

The problem with the code was that Im using a norwegian excel, and the VBA commands are english, and not recognized in the worksheet, using "norwegian" syntax in VBA vas not straight forward. Furthermore, I figuered out that writing functions in VBA with "=..." is not possible without modifications. The solution was to use makro record, and using that as a part of my code.

Thanks for your time, much appreciated, I learned alot and had good use of the .Value command.