hi all !
i have a cyclic vbe program that bob gave to me and it works fine..
but i need to open it in more than one windows simoultaneously, and when i
switch to window 2, the timer in the  window 1 stops !!

Is there a way I can get the cursor blinking in a specific cell just as if I
double clicked in that cell?
Thanks

A Macro in my MasterFile.XLS opens a New Workbook and pastes a copy of one of
the sheets into the new workbook. I want to then return to MasterFile.xls,
clear contents in cell C6 of the Input page  and then return to the newly
created workbook.

I'm trying to totalise some figures from a sheet. But I don't know how to
use cells in the where clause.
I tryed the code below, but I get error 80040E14 function objWb7.Cells not
defined.

I have dates in Column A, and data in Column B:E.
I am using this little snippet of code to insert NA into cells to force my
graph to plot correctly:
   Sheets("GRAPH CURRENT").Select

We have a spreadsheet with a few buttons on it. One of the buttons is
called Distribute Sheet. When the user clicks this button the excel
sheet is first converted to a pdf document and then stored on a
network drive. Once this is complete the source file is copied to

Say I have a variable called Height and I want to declare it as a Boolean
variable with possible values "Tall" or "Short" rather than True or False.
How should I declare it?
TIA

Dear programmers out there. I have come across a problem which I am
certain should be possible to solve. I have tried searching for it on
the discussion forum, but without any good results.
What I am struggling with is that I want the sc & i variable to

I have an excell sheet with several command buttons on it.
If I open that sheet from another PC on the network, the buttons don't show.
The code to run the buttons is available in the VB editor, but the objects
do not appear on the screen.

I have code below that I use to copy range of cells to other tabs that are
inserted by a user.  Is there away after this code to have the same macro
change the tab to what is typed in textbox1 for all 10 tabs?  Any help would
be appreciated.  Thanks

I hope this is a quick. I'd like a named range selection to include ActiveX
controls within the range so I can copy the range elsewhere.
What I've found is if I reference the range as "B77:AM99" the ActiveX
controls are included in the selection. If, however, I create a named ...

i need to do either one of two things...
i got about 200 cells that i need to copy and paste (from column n to c).
this is a part of the recorded macro
but the list continue to about "N380"

im trying to get a macro for the "edit" "find" (ctrl+f)
im gona put it in a form button

Currently I press F8 to step into a code.  Then I have to select a yellow
arrow and drag it down to where I want to start viewing the code, step by
step.
Is there an easier way to step into exactly where you want to, instead of

I have a data table that is sent to me from a 3rd party vendor and in the
cell the vendor uses letters to refer to what they mean for example:
c = Rock-Eval  analysis checked and confirmed
lc = Leco TOC analysis checked and confirmed