Technical Excel Issues | Forum profile

It is not saved in a methodical way but I have most of it knocking it around. Out of a years work I would lose a few days worth of raw data, and a few days work of processing it. (PS - The zipped version is the same size as the original)

Hi, you are right. I was no# one fool. I have found out it is called formula bar. Once again, much thanks.

Small point, but you shouldn't use an Integer as a row counter - always use a Long. Which version of Excel are you using, and does your code turn of screenupdating and calculation at the beginning? Oh, and do you have page breaks displayed?

It looks like you have some undeclared variables there, like "r1". I would recommend putting OPTION EXPLICIT at the very top of your module. This will force you to declare all your variables. Othwerwise, undeclared variables are defaulted to Variant. I don't know if this has anything to do with the behavior you are experiencing, but even if it doesn't, it is a good programming practice to get into.

status bar is at the bottom. Shows "Ready" or "Calculate" and other status messages, and other things. I don't know if that can be hidden in 2007 since it also has the zoom. Glad you finally decided to check out my instructions on the formula bar.

Found the answer. There was an existing link to another workbook causing a recalculation issue. This link did not show up using the "Find& Select" option in the Editing tool telling that the link was inactive. I broke the link and everything is now working normally. ...Maybe next time.

Sorted - it was down to having Workbook protection on! Doh!

I finally fixed this problem by first converting the Excel 2007 file (xlsm) to an Excel Binary file (xlsb) and then converting to an Excel 97-2003 file (xls). This sequence of events preserved the macro assignments and allowed the new xls file to be modified and saved in compatibility mode without producing an error.

Thank you. The code which I had posted is an extract of the module. The procedures not-posted are not inflating run-times, and so were isolated. (not posted) Further, the procedures not-posted are not called by those which are inflating execution times. As such, the module is appended with an Option Explicit, and r1 is declared as a Public Integer. The problem which I am experiencing seems fundamental. The fact that run-times grow suggests a...

6: Crop video a. To crop your movie video, you can just drag your mouse cursor from four sides and four angles. Crop by setting the crop values b. There are four crop values on the lower right part of the crop window: Top, Bottom, Left and Right. You can set each value to crop your movie video, and the crop frame will move accordingly. Note: With this DVD Ripper, you can convert DVD into different video/audio formats simultaneously. Part 2:...