Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #111388
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Cell to be activated, which is a result of a vlookup formula |
| Date | 2020-02-02 16:11 -0500 |
| Organization | A noiseless patient Spider |
| Message-ID | <r17dtt$daq$1@dont-email.me> (permalink) |
| References | <5c745c54-a2fb-4008-9d09-7ebcace666b3@googlegroups.com> |
> Hi, > could somebody please help me with some code for a macro? > > I have following formula: =VLOOKUP($H6&"-"&I6,'Stock sheet'!$A:$F,6,FALSE) > > After the result is displayed, I'd like the cursor to jump to that exact > cell, which it found in 'Stock sheet'!$A:$F,6,False). I tried Goto, but it > doesn't work. > > Thank you! > > Regards, > Norbert GoTo only requires the target address; - ",False" belongs to the VLOOKUP function! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Cell to be activated, which is a result of a vlookup formula Norbert <nobbejagger@gmail.com> - 2020-02-02 08:31 -0800
Re: Cell to be activated, which is a result of a vlookup formula GS <gs@v.invalid> - 2020-02-02 16:11 -0500
Re: Cell to be activated, which is a result of a vlookup formula Claus Busch <claus_busch@t-online.de> - 2020-02-02 22:23 +0100
Re: Cell to be activated, which is a result of a vlookup formula Norbert <nobbejagger@gmail.com> - 2020-02-03 21:54 -0800
Re: Cell to be activated, which is a result of a vlookup formula Norbert <nobbejagger@gmail.com> - 2020-02-03 22:04 -0800
Re: Cell to be activated, which is a result of a vlookup formula GS <gs@v.invalid> - 2020-02-04 04:34 -0500
csiph-web