Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > remove formula from cell, leaving formula result intact

Thread Tools Display Modes
Old 12-10-2003, 02:17 PM
pemnuts pemnuts is offline
Join Date: Jun 2003
Posts: 57
Default remove formula from cell, leaving formula result intact

I have a vba sumproduct formula that gets inserted into a row when an order is finished processing. It counts a certain amount of events for a given order, then puts the grand total of events into the cell.
Is it possible to have the formula removed from this cell, but leave the count of events that it had found intact with code?

I am looking for a work-around for a big problem. Everything was fine until I found out that purchase orders can be duplicated over time.
I thought that if I had some code to go through my data range and look for completed orders, that it could remove the defined range sumproduct formula, and leave just the results of the formula in the cell.
Hopefully, It could be added into my Save and Exit command button code.
Reply With Quote
Old 12-10-2003, 02:54 PM
Kluz's Avatar
Kluz Kluz is offline

Super Moderator
* Expert *
Join Date: Oct 2003
Location: Lake Bluff, Ill., U.S.
Posts: 3,353

Replace the A1 with the cell of your choice:
Range("A1").Value = Range("A1").Value
No the other right mouse click
Reply With Quote
Old 12-10-2003, 05:20 PM
pemnuts pemnuts is offline
Join Date: Jun 2003
Posts: 57

I'm in too deep at this point.
My workbook is too advanced for me to make it work out. =(
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Executable making help???? Ekta General 5 11-24-2003 12:51 PM
create win2k user account sven General 5 10-31-2003 03:40 AM
Automatically run macro when formula result changes cell values longsearch Excel 3 08-26-2003 11:40 AM
How to add a formula in a cell with code _VBA_Addict Excel 13 06-18-2003 12:12 PM
Copying formula from cell to cell when writing VB code Carl Excel 6 04-30-2003 04:09 AM


Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..