LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Response to Steve for Formulas not "saving"

Sending this as a NEW mail, due to Runtime errors received on "Reply" emails...ugh.

Oh Steve.

Your VBA comment has me worried: I found a code in this newsgroup the other day that I thought would automatically hide the blank lines in my workbook. Problem is, I know nothing about VBA - except how to display it. That didn't stop me though - I went into VBA and added the code I found to my worksheet. I then saved the book as TEST, and forgot about it as I didn't know how to run the code to see if it worked.

The workbook I'm having the formula problem in is different than the test, and I've gone into each worksheet in VBA and verified there is no coding showing. Although, when I open the properties for "this workbook" (in VBA), there is a line that says "Saved" and the next column reads "false"... I have no idea what that means.

I just checked the TEST book, and the coding I did the other day, is not there....which only proves I had no idea what I was doing... but if that's the case, then VBA is not the problem...right? Though - the properties for this workbook on the Saved line show True.

I'm sorry to spew so much information - yours is the only response the hit the closest to home. I know I wasn't working on a "temp" copy, because my non-formula changes were saved! And I wasn't working on a network copy either....

SO. If you don't think it's VBA, I'll just make a few fixes, save them, test them, and go from there!

Thank you!
Carol

 
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
Two cells look identical but give false response to "Exact". Lake Oswego Excel Worksheet Functions 5 February 26th 10 04:38 PM
Slow response of "File-New" function RobWN Setting up and Configuration of Excel 1 April 4th 08 04:31 AM
Formatting "IF" response based on "OR" function veggies27 Excel Worksheet Functions 5 March 19th 08 07:12 PM
VLOOKUP won't generate correct response for "inbetween" values NavyPianoMan Excel Discussion (Misc queries) 9 August 28th 07 02:28 PM
Formulas not "saving" Carol[_3_] Excel Programming 4 October 23rd 03 05:09 PM


All times are GMT +1. The time now is 08:54 AM.

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

About Us

"It's about Microsoft Excel"