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.

Changing a formula that is copied and pasted using vba with excel 2000
 

Just a 'shot in the dark' but could the 'new' workbook have ben opene
in read only mode

--
Message posted from http://www.ExcelForum.com

Changing a formula that is copied and pasted using vba with excel 2000
 

-----Original Message-----
Just a 'shot in the dark' but could the 'new' workbook
have ben opened
in read only mode?


---
Message posted from http://www.ExcelForum.com/

.
Thanks for the reply. When I open the workbook I enable
the macro's, and when I look at the properties it does not
show as read only. Is there somewhere else that I should
look? Tom.

Changing a formula that is copied and pasted using vba with excel 2000
 

-----Original Message-----
Just a 'shot in the dark' but could the 'new' workbook
have ben opened
in read only mode?


---
Message posted from http://www.ExcelForum.com/

.
I found it. My fault, I had another procedure that was
being called that I "forgot" about. Thanks for the
input. Sorry for the trouble. Tom.