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


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

Re: Excel VBA Code for Old Value New Value

Path csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!buffer1.nntp.dca1.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail
NNTP-Posting-Date Thu, 24 May 2018 15:49:01 -0500
From Jemmeyson <Jemmeyson.154cdab8@excelbanter.com>
Newsgroups microsoft.public.excel.programming
Subject Re: Excel VBA Code for Old Value New Value
Date Thu, 24 May 2018 20:53:18 +0100
Message-ID <Jemmeyson.154cdab8@excelbanter.com> (permalink)
Organization ExcelBanter.com
User-Agent
X-Newsreader
X-Originating-IP
References <Jemmeyson.15490258@excelbanter.com> <XnsA8E9AF3205AD4auricauricauricauric@85.214.115.223> <Jemmeyson.154a29a8@excelbanter.com> <XnsA8EA8F6984ADCauricauricauricauric@85.214.115.223>
Lines 15
X-Usenet-Provider http://www.giganews.com
X-Trace sv3-wREskyd7YV9mYNGqptqxU97Gj5XOSQU5cf6s6+MJSwVUDcM8mAq9iYR1ZHv7I82BwSI/7Wy9MlUjO2k!9BpfvlFSP9vwDn8Omx2T8Zbjn/eJ6Apc7m+nK5wE3oMtTF9JVDnYvBLhtOPB5YQ9Nwm7Rq0U90sH!zyeV2c9vcwY=
X-Complaints-To abuse@newsgroupbanter.com
X-Abuse-and-DMCA-Info Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info Otherwise we will be unable to process your complaint properly
X-Postfilter 1.3.40
X-Original-Lines 7
X-Original-Bytes 1450
Xref csiph.com microsoft.public.excel.programming:110675

Show key headers only | View raw


Hi Auric

I tried your VBA in a new blank worksheet and CELL A5 is not recording
the old value from A4 regardless of Saving and Closing the workbook.

Any further thoughts on this?

Also, is there a way to dynamically see the change as opposed to closing
and re-opening the sheet?




-- 
Jemmeyson

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


Thread

Excel VBA Code for Old Value New Value Jemmeyson <Jemmeyson.15490258@excelbanter.com> - 2018-05-21 23:34 +0100
  Re: Excel VBA Code for Old Value New Value "Auric__" <not.my.real@email.address> - 2018-05-22 00:13 +0000
    Re: Excel VBA Code for Old Value New Value Jemmeyson <Jemmeyson.154a29a8@excelbanter.com> - 2018-05-22 20:21 +0100
      Re: Excel VBA Code for Old Value New Value "Auric__" <not.my.real@email.address> - 2018-05-22 21:05 +0000
        Re: Excel VBA Code for Old Value New Value Jemmeyson <Jemmeyson.154cdab8@excelbanter.com> - 2018-05-24 20:53 +0100
          Re: Excel VBA Code for Old Value New Value "Auric__" <not.my.real@email.address> - 2018-05-25 09:03 +0000

csiph-web