i have an unusual question.
Is it possible to reverse any text in excel using vba?
for instance when i type "excel" it would look like "lecxe" on the screen.
regards,

I think there are 8...7 IF statements and then the AND/OR under them.
Any suggestions for rewriting this to fit under the limit.  I can pull
the first IF into VBA code but the references get quite difficult and
lengthy...but it can be done.

is there any way to go back to a previous cell?  Say am in a1 and hit enter
(or tab), is there any way programmibly to get back to the cell (or at least
get it's address) automatically with out knowing the cells name or position.

I have a list of numbers with all in same column.   When clicking normal
autosum function, Excel determines the sum range for me, including subtotals
& grandtotals.
How can this happen with same effect in VBA language so that I need not

I have a list of names in Column A, with various numbers which
represent a date difference, in columns C:F...
I need a button to activate some form of input field so that the user
can select the name from a list, and then record some dates for that

Dear All,
This is the problem haunting me for long time , i am very expert in VBA
. hope some will give me solution
Have workbook with call status , with 15 columns 11th column give the

Just trying to broaden my Excel knowledge and while looking around i
noticed you can add Coding to an actual worksheet through the tab at
the bottom.
Can you please explain wat this would be used for and please give me

So I've got the following code that brings up a message box when
someone inputs something into cells G5:G350.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)

can anybody tell me how to use a macro from another excel sheet.
Situation :
I have 1 file called records.xls
This file has to be overwritten every time when filled (export from access).

Hola Folks,
environment:
- Excel 2003, VBA, Add-In (XLA)
I have added several menuitems to the Excel menu during the

I have 2 problems here:
1. How do you remove all the symbols from a column?
Like, all of these: !"£$%^&*()_+-={}[]:@~;'#<>?,./¬`|\  without
deleting them one by one from a cell?

Hello and goodmorning, I don't know if this is possible but I would like to
pass an object to an event. I want to do something like this:
sub main()
dim somearray(50) as string

I want to add everything that is in column B into Column A. How can i
do this effieciently?

i am a new user to excel vba programming.
i have a excel sheets with some fields like name ..... date...etc
if i enter date cloumn into the excel sheets then i need to delete that
row form that sheet and same row need to be inserted into another excel

The code below only runs if the Target.Address = "$A$1" . If i change the
Target.Address to ="$B$1" and make a change to cell B1 the macro won't run.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then