Macro functionality

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
My apologies, I'm a still a bit green with the coding. Maybe i should have
rephrased my question a bit better. I was looking for I guess the proper
syntax or actuall code that would allow me to not replace a formula with it's
given value or not copy a formula all the way down in a certain column. I
hope this makes sense.
 
This doesn't happen automatically, so you have to specify what
conditions occur that cause these changes that you want to prevent.
 
Thank you guys for all your help. I was able to find a function that should
hopefully remedy this situation.
 
Back
Top