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

charlesdh · #1 03-28-2015, 12:06 PM

Hi,

If the code failed you may need to "Reset" it. The problem with worksheet function is there are a pain to use.

In the same module try this code to reset the worksheet event.

Code:

Sub Reset_worksheet
Application.EnableEvents = True
end sub

Then run it. Then try your worksheet code.

grayson1231 · #2 03-28-2015, 12:36 PM

Nothing yet. Can it be something at the top?

Worksheet_Calculate instead of Worksheet_Change

I feel as if it has something to do with this event but can't figure out the corresponding moves once I make the change to "Calculate"

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