Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110062
| From | Claus Busch <claus_busch@t-online.de> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: VLOOKUP formulas only set to values |
| Date | 2017-06-08 11:09 +0200 |
| Organization | A noiseless patient Spider |
| Message-ID | <ohb42f$rt9$1@dont-email.me> (permalink) |
| References | <c6cb4145-a349-4897-8c8b-aae0deb1ae91@googlegroups.com> <ohaq3s$up2$1@dont-email.me> <d1e25160-f671-4126-a17e-e95ba1fc1d77@googlegroups.com> |
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.
--
Windows10
Office 2016
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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