Macro functionality
 

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!

Macro functionality
 

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!

Macro functionality
 

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.

"Pete_UK" wrote:

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!

Macro functionality
 

This doesn't happen automatically, so you have to specify what
conditions occur that cause these changes that you want to prevent.


On Nov 16, 12:03 pm, JC746 wrote:
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.



"Pete_UK" wrote:
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! - Hide quoted text -

- Show quoted text -

Macro functionality
 

Thank you guys for all your help. I was able to find a function that should
hopefully remedy this situation.

"ilia" wrote:

This doesn't happen automatically, so you have to specify what
conditions occur that cause these changes that you want to prevent.


On Nov 16, 12:03 pm, JC746 wrote:
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.



"Pete_UK" wrote:
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! - Hide quoted text -

- Show quoted text -