Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110063

Re: VLOOKUP formulas only set to values

Newsgroups microsoft.public.excel.programming
Date 2017-06-08 08:13 -0700
References <c6cb4145-a349-4897-8c8b-aae0deb1ae91@googlegroups.com> <ohaq3s$up2$1@dont-email.me> <d1e25160-f671-4126-a17e-e95ba1fc1d77@googlegroups.com> <ohb42f$rt9$1@dont-email.me>
Message-ID <fb2953a8-18d3-4d19-bbdf-a08ea8dbb4eb@googlegroups.com> (permalink)
Subject Re: VLOOKUP formulas only set to values
From "L. Howard" <lhkittle@comcast.net>

Show all headers | View raw

On Thursday, June 8, 2017 at 2:10:03 AM UTC-7, Claus Busch wrote:
> Hi Howard,
> 
> Am Thu, 8 Jun 2017 01:55:18 -0700 (PDT) schrieb L. Howard:
> 
> > It errors if there are no VLOOKUP's on the sheet.
> 
> check strRng for <>"":
> 
> If strRng <> "" Then
>          With .Range(Mid(strRng, 2))
>             .Value = .Value
>          End With
> End If
> 
> 
> Regards
> Claus B.


Hi Claus,

I just noticed that the returns are all changed to the same value.
I was looking only at the cells to see if the formula was gone, which it had, but the results are identical for all the cells with vlookup.

Howard

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

VLOOKUP formulas only set to values "L. Howard" <lhkittle@comcast.net> - 2017-06-07 16:51 -0700
  Re: VLOOKUP formulas only set to values Claus Busch <claus_busch@t-online.de> - 2017-06-08 08:20 +0200
    Re: VLOOKUP formulas only set to values "L. Howard" <lhkittle@comcast.net> - 2017-06-08 01:55 -0700
      Re: VLOOKUP formulas only set to values Claus Busch <claus_busch@t-online.de> - 2017-06-08 11:09 +0200
        Re: VLOOKUP formulas only set to values "L. Howard" <lhkittle@comcast.net> - 2017-06-08 08:13 -0700
          Re: VLOOKUP formulas only set to values Claus Busch <claus_busch@t-online.de> - 2017-06-08 18:08 +0200
            Re: VLOOKUP formulas only set to values "L. Howard" <lhkittle@comcast.net> - 2017-06-08 09:40 -0700

csiph-web