As I understand it Excel displays data according to the Format of a Cell but
calculates using the underlying value. One can get at the value but using
Cell.Value. Please correct this if I'm wrong as I'm no expert! Now I've come
across many cases where this has made it appear that ...

The following failed to sort just two rows (in over 1600) in the data:-
   Selection.Sort Key1:=Range("D1"), Order1:=xlAscending, Key2:=Range("E1") _
       , Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
       False, Orientation:=xlTopToBottom

I have this piece of vba code:
Option Explicit
Option Base 1
Dim Budget(1) As Single

I have sheet1 that contains Data in column A and B.
A    B
5    3
7    10

Greetings all,
Excel adjust the chart functions (Data areas Chart is using) automatically
when I insert the row or a column in the middle of the chart area. Can I
invoke that Excel functionality from the macro without inserting anything?

Ive been trying different ways all day to get this to work..thats how i
found this thread..nothing ive tried off of here so far has worked and
im sure its simple and the answer is here somewhere but my eyes are
starting to go the shape of my monitor..

I want a chart to update so that I can se either next column or previous
column in the chart. I want the user to push a commandbutton (next column or
previous column) to see data from one column at the time. The first column is
the x- values and the rest is the y- values.

I want to use a macro in a worksheet. In the worksheet, I have to select
only some columns, not all. Now, the number of rows are also refreshed daily
in that sheet.
I have to apply conditions also in that macro for selecting the particular

I have the following code to read into two drop down lists from an
array. The first reads the first row of the array and selects an item
from it. The second list is populated from the entries in the array
column for the item selected from the first row.

Hi Grp,
I want to create an utility for uploading data ( data which needs to be
fetched from any database)onto the excel sheet and after making changes into
the data, i also want it to store the chages into database. Is there a way

hello  I have alteast 1000 rows and 1 column in excel sheet and each
cell in the excel sheet has a formula. I need to track the change in
each cell. If i were using excel_change event it would have been easy
for me to track the address of the changing cell. Since i am using

I'm trying to create a function that will tell me if X numbers out of 4
are equal.  Something like:
Function AnyXEqual(x As Integer, int1 As Integer, int2 As Integer, int3
As Integer, int4 As Integer) As Boolean

Hi there
Is there a vba code to prevent user deleting an XLS file when the file
is closed and the XL app is closed
i.e. simpley prevent deleting the file while it is closed

Hi I need a code that moves a command button named AdjLeft, I cannot use
increment as the position depends on the width of column a A.
EG: if column a is 22.86 wide the position of button AdjLeft needs to be say
15.25

A while back I lost my macro record button.  When I added the "Stop
Recording" toolbar back the record button is grayed out.  I have tried many
times to get it back but nothing.  Its getting old going through the menu to
record a macro.