Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109106
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly |
| Date | 2016-07-25 14:21 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <nn5lc0$rhl$1@dont-email.me> (permalink) |
| References | <38106ca8-93b6-4266-a837-c8820827a96a@googlegroups.com> |
This is working for me...
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect([AJ6:DT105], Target) Is Nothing Then
Range("last4SessionsCalculations").Calculate
Range("rolesSuggested").Calculate
End If
End Sub
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly David Godinger <daveg7@gmail.com> - 2016-07-25 10:45 -0700
Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly GS <gs@v.invalid> - 2016-07-25 14:21 -0400
Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly David Godinger <daveg7@gmail.com> - 2016-07-25 19:07 -0700
Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly GS <gs@v.invalid> - 2016-07-25 22:44 -0400
Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly ltomama0945 <ltomama0945@gmail.com> - 2016-07-27 02:50 +0100
Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly edelkochen <edelkochen@gmail.com> - 2016-07-27 04:07 +0100
csiph-web