Replace Cell References In Formulas With Their Actual Value

**jamilm** · 07-19-2013, 01:14 PM

Rick,

this is excelllent. i found it very useful.

cheers,

**Rick Rothstein** · 07-23-2013, 07:25 AM

Originally Posted by jamilm

Rick,

this is excelllent. i found it very useful.

Great! Thanks for letting me know.

**jamilm** · 08-18-2013, 08:40 PM

Hi Rick,

while i testing this code. i faced the following problem. once i run the macro it only gets values from sheet2 not all three sheets. i have uploaded the file here https://skydrive.live.com/redir?resi...F--p4_QDGRNXkU

**Rick Rothstein** · 02-12-2014, 12:51 AM

Originally Posted by jamilm

Hi Rick,

while i testing this code. i faced the following problem. once i run the macro it only gets values from sheet2 not all three sheets. i have uploaded the file here https://skydrive.live.com/redir?resi...F--p4_QDGRNXkU

jamilm, I must apologize as I completely missed this follow-up question of yours (you must have posted it during one of my "away times"). I just tried to download your file from the link you provided, but it apparently has been removed. If you still have this question, can you send the file directly to me (my computer has been having problems for awhile now... it's in serious need of having Windows reinstalled, but I keep putting off doing that)? My email addresss...

rick DOT news AT verizon DOT net

Please mention the thread name so I know what your attached file pertains to.

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA