LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 1
Default Changing a formula that is copied and pasted using vba with excel 2000

I have created a workbook where I write formulas using vba
to copy and paste into specific cells. I have tried to
change the formulas in a newly saved workbook. Although
the formula shows that I have changed it in the VBA
editor, when I run the program, the values that are
returned are from the original formulas in the original
workbook. After making the changes I have compiled and
saved. If anyone can help keep me sane I would appreciate
it. Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using time data copied and pasted into excel from external source Ravi B Excel Discussion (Misc queries) 4 February 9th 09 02:35 PM
Date changes when copied and pasted JC Excel Discussion (Misc queries) 4 August 20th 08 02:46 AM
Delete the formulas of webpage, copied & pasted on excel sheet Mustafa Abedin Excel Discussion (Misc queries) 1 June 19th 05 02:39 PM
Formatting information copied and pasted from the WEB to excel jbsand1001 Excel Discussion (Misc queries) 5 April 5th 05 09:07 PM
How to remove hidden grapics from copied web page pasted in Excel. Crake Excel Worksheet Functions 0 January 24th 05 04:47 AM


All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"