I recorded a macro, trying to sort a column and then filter it paste to
a new column.
Does anyone find the code exceptionally long? I suspect it can be coded
neater but I'm novice. :confused:

Question -
When I am analyzing a formula in the formula bar, i can double-click on
any of the cell ids (ex. A2), hit F9, and have the entry in the formula
convert to the value in A2.  Is there any way to expand this

Basically, I've got some code which dynamically generates macros base
on the amount of autoshapes on my worksheet - what I now need to do i
get the code to assign these macros to the autoshapes - I've trie
recording a macro and then assigning the macros manually, but all thi

Excel gurus...
I have a spreadsheet that in Column C has descriptive data all in text
form. The data might say something like "Paul is an Italian basketball
player."

I’m trying to delete grouped shapes objects with name “Group 8”. On the
sheet are also other shape object (not grouped) which I won’t to delete.
The code which I write won’t work. I thing that something is wrong the
name, but I don’t know what. Can you help me.

need a quick formulae help from you in excel.
This is what am trying to do.
I have 2 sheets (A and B ) . From sheet B am taking the average of (A1:
B3) and want it in the A1 cell of sheet A.  To put it concisely

I am trying to use the VLOOKUP Function to look up values from different
workbooks. Instead of manually typing in the "table_array", I want the
"table_array" to be specified in a cell, and am trying to use an embedded
Text Function to return the "table_arraray” from that cell.

Three of my sheets in my workbook are almost identical, just slightly different data, with AutoFilter turned on in all three sheets.
I have it set up so that when I select a criteria from the AutoFilter drop-down on one of the sheets, the other
2 sheets are AutoFiltered the same ...

I need to create a column that letters the row.  For example, A1 is A, A2 is
B.  There are about 150 rows, so it needs to loop through AB, AC etc.
I would like to find a formula to do this so that if I add a row, it
recalculates the entire column.

I asked this question a couple of days ago and got a response (but the
response while it would work, did not fit into how I wanted to set up my
form) so I thought I would try one more time:
Is there any way to lock a Calendar control in such a way that someone could

I'm trying to using a dropdown form menu to do some calculations that
will access a function that has an array.  Please look at my code and
please point out what i'm doing wrong.
Public Function Test(j As Integer) As Single

Range D2:D100 has several values and some blanks.  I need a good way to
highlight the maximum value in this column and its matching value in column
C.  I'd like to highlight them red and bold.
I need CODE, NOT formulas in the cells since there are already formulas in

My search routine below
I can't seem to figure out how to add a little functionality
1. Currently finds a value and returns the value
  should retrun the cell ref such as A36

here is my original question
ok here is what i have.
      A     B     C      D         E
1      V     W     X      Y

What is the simplest way to read and write maybe 3 values to a text
file?
I want to use this as a global variables container so that all xls
files can be in sync.