Dear users,
I've been working on this quite a while, but was not successful. Maybe
you find the mistake or you know how it can be done better.
I have worksheet A and B. Its like a database: A is reporting (special

I have having using a macro to "save as" to a particular file
location. For some reason it was working and now it always saves the
file to "my document". I don't know what happened. Below is the code,
with the location I want to save it at in "local". Any ideas?

i have a list of statistics from a callcenter i work for that are all
in a table in excel, and i want to only select ones that apply to a
monday, 5th of the month and other specific dates (eg bank holidays)
how could i go about doing this or even is this posable?

I am trying to create a programme progress monitor for the projects in my
work. All comments on this problem are welcome.
I have a worksheet which monitors progress. it is based on the dates
referred to in a contractor's construction programme/ gant chart. For

Im currently using
=OFFSET(processed!$A$1,0,0,MAX(IF(LEN(TRIM(processed!$A$1:$A
$1000))>0,ROW(processed!$A$1:$A$1000),0)),32)
to dymanically set the print area under the

The simplest things can make me crazy.
I have a simple user form. It has three text boxes, and one button (OK).
The text boxes have their TabIndexes set to 0, 1, and 2, and the button has
it's tab index set to 3.

Hi I am putting the finishing touches on my quote system. Basically users
input the into one sheet, and which does the maths copies it over to the
'quote builder' sheet. I am looking for a failproof way that multiple users
can file the quotes, that automatically saves just the ...

I am creating a basic userform that enables a user to input currency
values in a cell.
Basically the  form has buttons for the numbers 0-9 and also for
"." (decimal point)

master worksheet named 'details' with cells containing all the
required data
other worksheets named such as e.g. 1000, 1001, 1002 etc in the same
workbook

I have developed a multi tabbed workkbook. The master sheet sends info to the
other tabs. In the Price cells the destination sheet recieves the value from
a cell on the master sheet which isn,t always the price I want to use. If I
make another

Pls see my example of the macro that i did. My intention is to find in
column G, cells that has either values of "AS", "HC" or "50", if found , then
for column P in the same row, it will return that value. But it does not
work. i tried to use selection.find but i cannot multi ...

I have a problem that i need some ideas or advice on how to solve it.
The problem =>
I have a list of products, qty & their unique id. I need to find the
total

I wrote a piece of code to generate a bunch of charts(>40) in a
worksheet. It was running smoothly and generate some beautiful charts.
However, last Thursday it stops due to a run-time error while running,
23 charts has been generated. The error message is "Unable to set the

I know this should be the simplest thing but I'm missing something.
When I open the file "accounting.xls" I want it to open the file
"cashups.xls" automatically.
Now... I've looked up VB help and as a result I have typed in

I want to BOLD all rows where a cell contains text "X" in any cell in
range.
Does anyone has the solution?