I connect to an Excel spreadsheet using Microsoft Excel Driver (*.xls) 4.00.6305.00 successfully and I am able to create a new table and insert data into the...

I have this in my column: 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 859+00.000 R 2 859+00.000 R 2

Will a single quote followed by x mumber of spaces then text negate the trim function?

I have a formula that gives me the average sales price for properties that fall within a certain value. I would like to break it down further by designating...

I have the following formula,...

I have a chart that I added a text box which I would like to reference a cell which contains a formula. Suppose cell c25 contains the formula =sum(C2:C23)....

I need a macro or code that show or hidden a Label box when a condition in a cell X is true or false. A will appreciate any help from you

I have about 4000 dates in a spreadsheet, some of the dates are in the 'mm/dd/yyyy' format and have no problem with them; however, interspersed throughout...

I have macros that generate graphs embedded in a spreadsheet. These graphs also auto populate a title and series names based on the data. On my laptop the...

I have a set of numbers where I need to find the highest value and the next highest value. I can use MAX to find the highest, but how do I find the next one?

I am trying to save a file and I keep getting the error message "You don't have permission to save in this location. Contact administrator to obtain...

Hi Quick question - can Excel Templates contain macros? Thanks A

Hi, I have a datasheet and every column is given grade as per their headings in columns and these grades have a particular value e.g. A = 50 B = 60 C = 70 D...

We suddenly find that we are unable to close the Excel application until each individual workbook is closed. Unfortunately this includes the hidden...

Ive got a string of weekly data ranging from 1993-2010, which i need to convert from weekly to monthly. Id like to do this so that in the future new weekly...

Hi, I'm trying to write a macro the deletes all rows that don't contain the numbers 10 in row A. The numbers will range from 102000 to 1099999. I want to...

I have a workbook w/ sheets and need to get them out of the w/book and into a file. I have tried to move/copy and also just copying the sheet. Any ideas?

Hi, i need an macro to select all filled cells in range C10:K90. Can this be done? Thanks!!!