On rare occasions Excel 2003 (with all updates) screws up and will display
just one sheet with impossibly tiny text - like only one or two pels high on
the screen.  All other sheets continue to look normal. All the cells appear
to still have correct information in them, it's just ...

In Excel, when setting the x axis values from a macro one can set the
value scale using
Axes(xValue).minimumscale = 11111.  I also need to set the scale on the
y axis. Excel calls the y axis something odd and I can't remember or

I am in need of some experts to guide me in my spreadsheet. I am trying to
put an accountibility sheet together and I would like to do this. I have a
subject in A1 cell. that is constant. And I have given B1 a constant value.
Now In cells C1-H1 I will be inserting a daily count. ...

Hello. I think a certain colome of cells got swieched some how. with out
movingthem by hand how can I re swotch them? thanks. example
13b is where 12b is supposed to be. Thanks.

I need to create an alphabetical index for a directory using a
concordance file that is saved in an Excel Worksheet. Currently each
row contains a column for "number" and "additional terms" fields. Below
I have listed one example:

I use Docmd.OutputTo in Access2003 to send the data from a report to
Excel.
I tell it to use a Template which has 1 macro assigned to it.
The OutputTo function saves it as a XLS file but the macro doesn't make

On an Excel 2003  spreadsheet which is much wider than any screen it is
inconvenient if cell labels do not stick in the position they are left.   I
am finding that when I reopen the spreadsheet the labels may have moved
horizontally to the left hand side of the spreadsheet  (not ...

Sir ,
i want to numbers written in cells be displayed as grouped in indian format
i.e. a number of 123456.00 can how be automatically group as 1,23,456.00
instead of 123,456.00

I am a Vba/Excel fanatic and have made several succesful applications. I was
wondering, however, how can I use VBA with other data bases such as MySQL?
What is the procedure for migrating to other data bases? Could you give me
some advice for using a succesful application with a ...

I have a formula that outs out net margin which is
=(Margins!$C$6-MIN-'TMobile 18 Costs'!D5)
I also have another formaula that turns negative into positive If a
positive states "FOC"  if negative adds VAT and rounds up to nearest

I want to click on a cell and have only the cells that contain data in that
colum to be visible.(Lets assume I click in cell b5, then I want only the non
blank cells in col 5 to be visible)(ie the same as using "SELECT all NON
BLANK cells)

Does anyone know if there is a limit on the size of a macro in Excel 97.
The reason i ask is that when i get to a certain point in writing a
macro, excel bombs when i try to load the spread sheet containing the
macro. If i just paste the macro in from a copy i made in word, excel ...

    here is the file: http://www.mytempdir.com/935740
First sorry for my english....
I have this code to insert letter "E" in column N of a sheet GAF only
if the

I am new to VBA & Macros. Appreciate any help I can get. I have a macro that
strip's data from a string and it works fine except I need it to strip
further in the string.  example of results:
bunder_linn-S1/0-720L-140.55.135.34-NIPR-1.5M(In)

i have created a spreadsheet which only uses columns a-f. i would like to
crop this area or remove g onwards so g onwards is completely blank or a grey
area. any ideas? i can't find anything in the search for help database b ut i
know it can be done as i have seen other workbooks ...