I need to find the end of a Pivot table I call "Won" the table sorts orders
out and is constantly growing. I need to find the last cell of that table at
any given time after it is filtered so I can add some notes and other info to
the bottom. I have tried range names but when the ...

I am trying to consolidate data from two data sources.  Some data is numeric,
some is text.
I have tried excel pivot table, multiple consolidation ranges but can't get
the text to appear - it tries to count or sum and doesn't show the text.

I have created a hidden worksheet containing a table I would like to use as a
template.
Basically the table is 22 columns by 462 rows
462 names of places

To all,
I have a series of comma seperated text files. One for each day of the
year. They are identified by the title RD071107, RD071108 etc. - This
denotes the date that the data was collected (yy/mm/dd). In each text

Recorded a macro (in Excel 97) that places border around each selected cell.
But when I run that macro I get err 1004 "Unable to set the LineStyle
property of the Border class".
It's fine if I delete references that try to change xlInsideVertical or

Hai iam creating standard template where cells having different formulas &
validation. My query is i dont want to left any cells blank. Is there any
macro to find the blank cell (within certain range) and if it find blank
cell, error message has to come stating  particular cell ...

Looking for code that will select/highlight a range and then name it. The
range is an Excel download that varies in size. A user can run several
downloads per day hence the need to automate the process. It would be cool to
have some kind of pop up box that allows the user to type ...

I have to sheets named "Data" and "Test". Data sheet contains everyday
sales amount in row A2:D2. eg.
Data Sheet
Date    Agency    Dealer    Corporate

IS it possible to add menu bar to Userforms ,if so then how to Add menu bar
and menu items in user form. Please help.
Thanks

This might be a more complicated question than I realise. However I want to
insert a 24hr clock into (a) worksheet(s). Data in one sheet must be
transferred to another worksheet after the day is complete. So I can start
entering new data the next day. Can this be created? Please ...

Hi evry one
I'm using same semple program for accounting it's was working good
in one PC.
But when I trai to move it to anther PC This

Office XP.  I have a vbcript-based asp page that generates an excel
spreadsheet.  It works fine when it is inserting all english text, but
when I try and insert german instead I get this error:
"Cannot set the text property of the character class".

Can someone advise me the difference between if i use
activeworkbook.usedrange.row vs if i use lastrow=row.count.xl.up? Which
should i use if i want to delete those blank rows that are copy from another
wksheet via macro so that the last row will be the one with the data?

I know how to clear the contents of cells in a macro,ie.
Range("A1:B50").ClearContents - however can anyone tell me what needs to be
included in a macro to clear "Borders" created around cells for a given range.
I am just getting into creating macros - so if the above is not clear ...

I made a macro which does some changes in the workbook and saves it with a
new name. But I forgot one possible error - the file with the new name still
exists, macro will rewrite it. Someone in network can have opened it at the
moment I want do rewrite.