Macro will not read the value of cell with a formula in it!

charlesdh · #2 03-28-2015, 11:49 AM

Hi,

Possible solution is to have this bit of code "If Target.Address(0, 0)" refer to "Text"
"If Target.Address(0, 0).text".

Update to add more info.

When using code as you have you should use the "Application.EventDisable = true"
This should stop the code from repeating itself.

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False

''''' then reset Event at the end of your macro

Application.EnableEvents = True
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Read cell from one table into another	donaldadams1951	Word VBA	2	02-04-2015 06:46 PM
Macro to copy formula from one cell to another	anwar	Excel Programming	1	04-25-2014 08:27 PM
Formula in cell b1 using cell a1 if a1 is over certain number	pumkinbug87	Excel	5	12-03-2013 12:34 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
how to read R1C1 formula	Suhanti	Excel	2	10-16-2010 11:30 AM