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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macro will not read the value of cell with a formula in it!

#10

03-28-2015, 01:46 PM

charlesdh

Windows 7 32bit Macro will not read the value of cell with a formula in it!

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

Oops, I just noticed the you have
Target.Address(0, 0) set to 0,0. I think it needs to reference an actual address.

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 PM.