I need a fresh pair of eyes so hopefully someone can help....
I have a list of data and what I want to do is copy the values in coloumn A
pasting them in cell D4 (other actions area then performed). I have been
trying to use the active cell method but the problem I have is that when ...

How can I ensure that A1 is in the top left corner of my screen and
then the cursor is in K6?
I've tried below but it doesn't work
Sheets("Sheet1").Activate

I'm not sure whether this is the right forum for this question, but I was
wondering whether anyone knew of a tool that could take an Excel spreadsheet
and export all of its calculations to a source code format (preferrably C#)
so that these calculations could be built into an ...

I'm having trouble working out how to do this:
Loop through all worksheets in a workbook, returning the sheet names to a
range on the first sheet, i.e.
On sheet 1, cell A1 contains the name of the first worksheet, cell A2

Has anybody ever experienced this before?
Has anybody got a clue how to fix it?
Somehow something has happened to my Excel2003/PC (running on XP) so
that I can go into the Immediate window and run the first line below,

I'm using an activex combobox that I have placed over a cell on a
spreadsheet. The combobox refers to a table on another sheet and is
populated using additem and the DropButtonClick event.
***In order to clear the contents of the previous DropButtonClick I

can any one help me with a function which transforms ascii values to
character, tobe used in Macro for column referance

=BLPH(A1,B2,"28/2/2001","17/4/2007",0,FALSE,"D","N","
",TRUE,1600,2,FALSE,"P"," "," ")
I am trying to get a macro to input this formula in cell A1.
I've used the following line of code:

.....is this true ??
Which means that it will also be true when stepping through and
executing "?Application.Screenupdating" in the immediate window ?
Regards,

as part of a VBA macro in an Excel workbook, I am trying to open a CSV that
has date fields in. Workbooks.open doesn't give me consistent date or text
fields so I can't order them, so instead I am using OpenText.
The problem is that, while I can now open the CSV correctly, I don't ...

I have some code which updates the links for named files
Sub UpdateLink1()
ActiveWorkbook.ChangeLink _
"\Forecasting\FY2006\1106\OpsPlan\1106JudgementPaperLinksv003.xls", _

I am writting a SQL sentence in msQuery and it says "Impossible to add
(SELECT table", in the next sentence:
SELECT id_User,id_PC,vTime FROM (SELECT 1 AS PC_new.id_User
`c:\PC_office`\PC_new.DBF PC_new UNION ALL SELECT 2 AS PC_old.id_User

I am using Excel 2007. I can't find the YIELD method that once worked in
Excel 2003 in VBA?  I believe that it was part of ATP.  Now its nowhere and
the VBA code is now broken...help please!
Thanks!

I would like to have excel auto number a new work sheet every time I print a
new sheet.  The form that I have created has the page numbers in cell I3 and
only has to number from 7 to infinity.

Hi all, i have struck a blank and must have this finished by morning !!
need to go down column A of workbookA and look up the value of the cells
in A in workbookB, if found place the order number from column G in the
column AM of the workbookA. I have tried various options from this ...