Is it even possible to use VLookup in a Basic Macro? I keep getting the Parenthesis Do Not Match Error. It's very confusing to search because most search results aren't totally clear on the difference between using the function on a spreadsheet versus using it in a macro.
Any quick help is appreciated...maybe I depend on it too much.
Possible to use VLOOKUP in a macro?
-
- Posts: 16
- Joined: Sat Sep 15, 2018 9:05 pm
Possible to use VLOOKUP in a macro?
OpenOffice 4.1.5
Windows 10 Pro 64-bit
Windows 10 Pro 64-bit
Re: Possible to use VLOOKUP in a macro?
Yes, you can use the cell functions in your macro code, but you must pass the arguments in an ARRAY type variable to the called function.Possible to use VLOOKUP in a macro?
Here are some examples (the simple textual range name like "Sheet1.A1:C24" will not work):
viewtopic.php?f=20&t=84945
viewtopic.php?f=45&t=24323
http://ooo-forums.apache.org/en/forum/v ... 20&t=42702
viewtopic.php?f=20&t=78686
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Possible to use VLOOKUP in a macro?
Moriturimax, can you upload an ODF type sample file here?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.