Yes, do provide an example. And post your code here, as well.

Pete

On Nov 16, 4:03 pm, JC746 wrote:
Good morning,

If anyone can shed some light on this issue I am having that would be great.
I am currently trying to revise a macro that was writen to format several
spreadsheets to have the same appearance and functionality. The problem I am
encountering is that I need certain data to be hard coded values in certain
cells versus a formula and vice versa. When I do have a formula, it's
converting it to a hard coded value due to it's placement on my spreadsheets.
Please let me know if there is any resolution for this issue. If this is
unclear, I'll gladly provide an example. Thank you!