Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Interuption with no explaination :/16 May 2007 16:20 GMT3
Hi. I've had this error a couple of times, and can't figure it out.
I write a macro and when running it I get "Code Execution has been
interupted" and when I debug it's on random lines...
Today i've wrote a macro, which I'll attach at the bottom. The macro worked
Answer MSGBOX Programatically16 May 2007 16:07 GMT6
I am writing a macro that opens other workbooks, calls macros in these
workbooks to update data and print some sheets.  When all of that is
finished, there is a msgbox funtion that let the user know this process was
completed.
writing a macro to delete all rows after a certain value16 May 2007 15:17 GMT3
I'm trying to write a macro for a spreadsheet that will have a variable
number of rows, but generally in the neighborhood of 18,000 to 19,000.  Here
is what I have, but it takes about 5 minutes to run so I'm trying to find a
faster way:
Command button code16 May 2007 14:33 GMT6
I have created a command button on a worksheet in an Excel 2003
workbook. I just need to assign some code to this button so that when
clicked, it will simply enter text into a cell in another worksheet in
the same workbook.
copy from worksheet16 May 2007 14:32 GMT3
Having the name of a worksheet in cell A1, I would like to extract
non-contiguous data from the sheet of that name and paste it onto my "Data
temp" sheet.
How can I get the data to extract from the named sheet onto the Data Temp
SCripting Border in Excel16 May 2007 14:17 GMT2
I am writing a script to populate an excel speadsheet.
All works ok until I try and but borders around the results.
The snipet of code below is how I have tried to create the borders but with
ne results.
The Macro "C:\Test\Something.xls!Macro" could not be found16 May 2007 14:11 GMT4
I guess this is somewhat a silly question, but I'm not able to figure it out.
I have made a macro, and I have assigned it to a button in the toolbar. But
when moving the Excel file to a different location, it can not find the
macro. How do I make it work wherever I put move the ...
date format changes when I save to CSV via a macro16 May 2007 14:06 GMT1
(reposted from General Questions)
(note: this behaviour seems to have appeared in Excel 2007 - in Excel 2003
the macro worked fine!)
> brawlsadford wrote:
Import data with Webquery16 May 2007 14:06 GMT1
I need to import data from web pages but I need only data from certain
cells, not the whole table. Excel lets me select tables only. Can anyone
suggest a solution for selecting individual cells as source?
Thanks.
Re : Excel Creation of a New Copy and the Duplication of Names thereof16 May 2007 14:05 GMT1
Re : Excel Creation of a New Copy and the Duplication of Names thereof
1. Enter an Excel workbook and construct a table on Sheet1.
2. Construct a similar table on another Sheet.
3. The natural tendency is to create a new copy of Sheet1 and
Excel 200316 May 2007 14:01 GMT1
Dear Excel Expertises,
I have an Excel spreadsheet of with features and models.
It looks like this in excel. The first column contains all the
features and the first row contains all the models.
How to determine the worksheet that a calculate event gets initiated on when the workbook is not active16 May 2007 13:58 GMT3
I have 2 workbooks thats are linked with a cell reference. I make a
cell change on book1 and a cell in book 2 changes. I want to be able
to get the name of the sheet that the calculate event runs on in book2
to hide rows that do not contain values. Currently my code runs on the
Array formula with IF16 May 2007 13:53 GMT4
I cannot work out what is wrong with my formula:  =IF(B3:E3-A3>=3,1,0)
I would like if any of the values in the range are greater than 3 more than
the value of A3 a "1" to be returned as I eventually will use the formula for
conditional formatting. When I enter this formula it ...
Add-In Password...!16 May 2007 13:35 GMT1
Could some one help me to recover my AddIn Password.
Thanks,
Thyag
Visibility of contents in a merged cell16 May 2007 13:26 GMT4
First I explain below what I did;
I merged cells from a1 to e17.
   Formatting :  Left, Top and yes for wrapping.
Then I kept key 'i' until the cell got filled up.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.