I'm trying to copy the values from A1 and C1 (only)
to my next sheet (sheet2) into cell A1:B1
Sub foo()
Dim Qcell As String

is there any way that Excel 2007 can be set to run in 2002 mode I need to
save a file as a DBF file and there is no DBF option in Excel2007 Many thanks

This is the 1st time this ever happened to me. My trace precendent tool is
working, but my trace dependent tool isn't. I know for a fact that the active
cell affects other cells. If I open up an older version of the file, both
tools are working. It's just this month's version. I ...

I have several users that do not know how to use Excel and need to change
formulas in a single column to obtain correct data for their needs.  I don't
want to issue unique files to each user, so I was hoping there is a way to
allow each user to select their specific formula from ...

I have a CT project due this coming up friday. It this quiz thing, no matter.
The problem is that I am tring to make a macro that would, for example,
change the list from "The Answer" to "Please Select". I don't know why it is
not working, but from what I've learned, macros only ...

i have 5 sheets of data  in the same work book containing information on
300ppls. Each sheets have the same properties in the first column (their
name)  How do i use drop down list so that when i use/activate it on the
first sheet  (for i.e. top10) the result can also be seen on ...

Since installing Office 2007 file format compatibility pack, I seem to have
lost access to VBA libraries. For example, I get error message "An error
occurred initializing the VBA Libaries (1004)" when starting Excel. I can't
find a way to uninstall the compatibility pack, or ...

We have Purchase orders type in excel all the way down with the same height
( number of rows is the same), now I want to convert so many purchase orders
to be row wise in order to maniputalte data liek sorting by material
description and then we know the lowest price historically ...

Whenever I am in Excel and want to save my workbook, The save options are
showing but are faint and are not available to click on. I can use the
shortcut Ctrl+S but I don't understand why the toolbar and file options are
not available.

Hi list,
is there any way to define different series for a scatterplot from a single
column?
I have data organised in three columns: column 1 and 2 contain the X and Y

I need to print a list of custom views that have been established. Is there a
way?

I have a spreadsheet with approx 24,000 lines of data.
There are 4 blank rows between columns A B & C and
I need to copy the information down into the four blank
lines for every record.  There is data in columns H onwards

I can't create or view spredsheets with color.  The colors and patterns will
display in the print preview, but not in the worksheet screen.  The video
drivers are up to date  and no other issues seem to be notable.  Is there a
way to fix?  Is there a way to completely reset all ...

is there a way to place the ± symbol on the tool bar so you can insert it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)

Is there any way I can create a excel pop up reminder on a specific date
without turning on the program?
Eg: Task A due on 2/5/07
There will be a auto pop up message to remind me maybe 1 month before the