Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 12th, 2004, 04:37 PM
Authorized User
 
Join Date: Sep 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cell returns its own formula after a macro!

Hi,

I've encountered a strange problem in a worksheet after I run a macro. After the macro is finished, the user wants to insert formulas in a particular column that concatenate "CS" with the contents of another cell i.e., ="CS"&BA1
However, the cell returns ="CS"&BA1
The problem is only in this particular worksheet whose output is heavily calculated by the macro. The workbook setting is "automatic calculation". In addition, the F9 key does not solve the problem, the formula just sits there! If I copy/paste the entire sheet to another new sheet, the formula calculates, but there is surely another solution to this.
Any suggestions are appreciated as this is driving me batty!
Many thanks

 
Old December 13th, 2004, 04:53 AM
Authorized User
 
Join Date: Aug 2004
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The cell needs to be formatted as General instead of Text.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.
 
Old December 19th, 2004, 03:48 PM
Authorized User
 
Join Date: Sep 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Brian. However, the cell was already in General format. I solved the issue by deleting the original sheet and inserting a new one. The problem hasn't recurred. It seems that the original user prevented calculation when they recorded the original macro, as all copies of that workbook had the same problem.

Regards,
Tim






Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Formula on Active Cell manojkumarsoni Excel VBA 3 August 26th, 2007 08:56 AM
What would the formula "=+D4" do in a cell? BrianWren Excel VBA 2 February 2nd, 2006 03:36 AM
Excel Formula End Range Changes when Macro Is Run maaron Excel VBA 0 October 11th, 2005 10:56 AM
Excel Formula End Range Changes when Macro Is Run maaron Beginning VB 6 0 October 11th, 2005 10:33 AM
Inserting formula into active cell alisonchase Excel VBA 3 March 3rd, 2005 10:06 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.