Hi All,
i am need to get this query done.
my query is, i have formula in cell as
and i want to add value to that formula using VBA code like
Please Login or Register to view this content.
and i try using below code , however its not getting done its showing error Type Mismatch.Please Login or Register to view this content.
can anyone please help me out with this.Please Login or Register to view this content.
thank you !
Last edited by Naveed Raza; 04-05-2016 at 08:44 AM.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
While I look at it please edit code tags:
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Here, try this:
Please Login or Register to view this content.
Hi Sir,
sorry ! due to hurry i forget to add Code Tags,
About query: its got resolved , just need to add below red highlighted line.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks