Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109960
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Help condensing 2 step process |
| Date | 2017-03-29 11:57 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <obglbc$8vc$1@dont-email.me> (permalink) |
| References | <d5b37f11-2395-4170-933f-e9568bf6d312@googlegroups.com> <o8guc7$lgj$1@dont-email.me> <o8ih06$dlb$1@dont-email.me> <47df96d9-4462-4f0f-b200-76a78f227fa3@googlegroups.com> |
> HERE---> If vRng(n, lCol2) > lWt Then _
> .Cells(n, 1).Resize(1, 31).Interior.ColorIndex = 0
The above is 1 line broken into 2 for posting only. Perhaps Excel is losing
track of its ref to the sheet so always safe to use fully qualified ref...
If vRng(n, lCol2) > lWt Then _
Sheets("TMS DATA").Cells(n, 1).Resize(1, 31).Interior.ColorIndex = 0
--
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
Help condensing 2 step process Living the Dream <noodnutt@gmail.com> - 2017-02-21 00:06 -0800
Re: Help condensing 2 step process Claus Busch <claus_busch@t-online.de> - 2017-02-21 09:41 +0100
Re: Help condensing 2 step process GS <gs@v.invalid> - 2017-02-21 18:05 -0500
Re: Help condensing 2 step process Living the Dream <noodnutt@gmail.com> - 2017-03-28 05:03 -0700
Re: Help condensing 2 step process Living the Dream <noodnutt@gmail.com> - 2017-03-29 02:31 -0700
Re: Help condensing 2 step process GS <gs@v.invalid> - 2017-03-29 11:57 -0400
Re: Help condensing 2 step process Living the Dream <noodnutt@gmail.com> - 2017-03-28 05:02 -0700
csiph-web