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

From Jemmeyson <Jemmeyson.154cdab8@excelbanter.com>
Newsgroups microsoft.public.excel.programming
Subject Re: Excel VBA Code for Old Value New Value
Date 2018-05-24 20:53 +0100
Message-ID <Jemmeyson.154cdab8@excelbanter.com> (permalink)
Organization ExcelBanter.com
References <Jemmeyson.15490258@excelbanter.com> <XnsA8E9AF3205AD4auricauricauricauric@85.214.115.223> <Jemmeyson.154a29a8@excelbanter.com> <XnsA8EA8F6984ADCauricauricauricauric@85.214.115.223>

Show all headers | 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