By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,589 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,589 IT Pros & Developers. It's quick & easy.

how to change the formula in each cell of an existing excel workbook

P: 4
hi,

In sheet each cell is define with pre-defined formula. what i need is to change all the formulae in each cell when i create a copy of these existing worksheets.
Jan 21 '10 #1
Share this Question
Share on Google+
2 Replies


tlhintoq
Expert 2.5K+
P: 3,525
Sounds like good needs.
Please provide the relevant portion of your code where you are having troubles, along with any errors that are being thrown and we will try to help you fix your code.
Jan 21 '10 #2

tlhintoq
Expert 2.5K+
P: 3,525
Hello Ram,

Welcome to Bytes. I couldn't help but notice that all three of your posts are regarding an Excel project and that all three of your posts are in the form of "I need this ...."

Here at Bytes the volunteers don't write your code for you. You need to at least make an effort on your own first. The MSDN has an entire section just on the Office namespace, which includes a section for Excel
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

You will learn a lot more by first reading the documentation, and working with the sample code already provided by Microsoft. Then when you run into some issues with your code we can help you with the specifics.
Jan 21 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.