| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save As Functionality | Excel Discussion (Misc queries) | |||
| Odd functionality | Excel Worksheet Functions | |||
| Go to functionality | Excel Worksheet Functions | |||
| Running of Worksheet Change Macro breaks undo functionality. | Excel Discussion (Misc queries) | |||
| Help with Countrows functionality within a Macro | New Users to Excel | |||
Linear Mode
