Hi
I have written a macro & Assign the same in Toolbar.
Each time when I run the macro,Excel prompts to open the parent file where I
have store the Macro module, to work with.

New to this forum and new to Excel VBA ;-)
This is my problem:
I have a worksheet with five columns, the first has values ending wit
numbers "01". I want to copy the rows, one by one, to anothe

I have a macro recorded in a game that optimises the view of the game on
screen in all but one respect.  When I have tried to add in the following
command it always trips up and launches the debugger:
Application.CommandBars("Worksheet Menu Bar").Visible = False

Can anyone point me in the direction of some sorting routine examples. I
could write a simple "Bubble Sort", but I used to have some code for what I
would call a "shell" sort which was much quicker. I tried searching MSDN but
its like looking for a needle in a haystack!

test Downloaded version of excel 2007 will not close normally when program is
shut down.  Wants to re-open and advises an error report.  Only when error
report and whether excel should re-open is not 'checked' does the program
shut down and not re-open.

Hi all, this is bugging me!, I want to set a range in a formula that is
always only the cells with stuff in, I was going to put make named
ranges with a button but it doesnt want to play! any ideas?
Private Sub CommandButton2_Click()

I have found what appears to be a glitch in an application I have made. It is
an educational program designed to generate new questions for the student to
practise each time a button is pressed.
I have included a drop-down menu, named as "Question_Type" so that the

I want to put a number in the cell and replace it automatic to text.
i have list of custmors and every one has a code example
101 mike
102 joe

Hi! I have columns A to J, all with a different number of entries (this will
vary with time, but they will never have the same number each). I need a
macro to take all the data from each of these columns (ignoring blanks) and
put it all into column K, so that cells K1:K... ...

Is it possible to add a footer to an excel doc. through VB code?
Any help will be highly appreciated.
Thank U all in advance,
Tej

I am trying to send a single row of data to an access database table.
Column in the spreasheet represent a column in the database table.
I want to append new records to the database and send backa reference.
how do i do this.

Dunno if this is the right place to post this but annyway: I have a
excel file with a bunch of data, and some how I want to view only th
posts with 30 chars or more. Is this possible
--

I've got a userform (called stagedetails) with a combobox (called combobox3)
that should always be the active control when the form is shown.
It works perfectly the first time but once a button on the form has been
clicked I can't change the focus back.

I have a table with real time statistics on. I would like to be able to
sort them in real time. How can I do that? Please help.
Thank you.

Currently i have:
If Range("AC1").Value = 39 Then
   Application.ActivePrinter = "\\OFFICE3\OKI C5200n on Ne02:"
   ActiveWindow.SelectedSheets.PrintOut From:=1, To:=5, Copies:=1, _