Can anyone refresh my failing memory on how to get a macro to move to a
given cell, wait until data is entered and then continue to the next line of
code?
Thanks.

Hi I have a worksheet that where I need to copy some of the rows to a new
sheet based on the value in a column.
Basically the sheet has 15 columns, and if the value in column H is either
ADD, ALA ALP, AMM or BEY I want to copy the entire row to a new worksheet so

Hi,
I have sheet, where there is a picture named Object 1 (an in formula bar is
formula =INSERT("Word.Picture.8";"") ) - this I need to leave on the Sheet.
Then there is Group11, which I need to delete

I am having trouble coming up with the correct function coeding for
this Excel database. I know I would need to use IF, VLOOKUP, INDEX and
ROW. But in what order and how I just cant seem to get it. When you
open the file you will see the sheet called Search and then there is

I have created a macro which copies some charts from 1 workbook to
another. This is repeated for several worsheets in 1 workbook. It
completes the entire task very well, however it crashes excel after
the macro is run. It does not allow me to save the workbook. What

Dear experts,
I have a problem with the "range" Object.
I would like to find out the extent of merged cells with the following:
Do

I have declared several constants at the top of Module1 such as:
Option Explicit
Public Const BM1Left As Single = 10.1
Public Const BM2Left As Single = 20.1

Good afternoon --
I'm creating a timesheet to record time spent on different projects.  Over
the course of a day, an individual might have over 10 entries, so the sheet
might have  couple hundred lines by the end of a month -- one entry to a line.

I have previously used the "choose" function for sum functions that would sum
a data range for a month-to-date display.  Recently we have found that one of
the updates we have ran has limited the number of agruments that the choose
function supports has been limited to 28 ...

I have the following list of product codes which I need to filter only for
codes ending with the last three 0's (zeros) and then apply a dropdown
validation list of the corresponding Product Name. I have tried using wild
cards such as * and ? but I cannot seem to get it to work.

I would like to know, programatically, how many pages will be printed if I
print a particular worksheet.
In the PageBreak view or PageLayout view it gives the page numbers but how
can I get that information programatically.

How do I code so a value from a combobox on a forms value will be entered
into a certain cell on a worksheet? Also item from a text box as well.

I'm using JLGWhiz's solution in posting "Deleting Column Based On Header"
to delete columns other than those correctly titled.  - Below -
It works Fine but only when run several times or repeated.
Can someone help me enhance to automatically loop until either desired # of

I created a PivotTable based on a SQL Server view. After refreshing
the PivotTable, an MS Query application window opens and remains open
even after the PivotTable is refreshed. Normally, when refreshing a
PivotTable based on a SQL Server view, I do not see the application

Hi is there a way to Search Excell ?
What I mean is I am creating a Form that allows the user to enter a name of
a software also a description the serial key and if it has been used. I want
to be able to let the user Search so they can type in serial and it will show