A user when he opens an Excel spread sheet it does not open completely excel file doesn't display, though status bar indicates 'ready'. Sometimes when he launches it a second time it does ope...
On an Excel spreadsheet I have ten checkboxes. Users can check off any number and save his changes. When user opens the spreadsheet another time he will still see his selections from the las...
How to transfer a variable or use global variables for macro code in different sheets in an excel worksheet
I want to separate the subroutines of my macro across different pages in an excel...
I have been playing about with the properties tab on a Check box. Is is possible to increase the size of the tick box? Only I cannot find a way in which to do this. It might be just set at a d...
i need to write a program that will automatically assign employees to specific work areas. i have no idea where to begin or how to accomplish this. There are three work areas. all employees ca...
This is related to Q_23768956 AND Q_23772011
I want to add the number of cells in a range that have a specific background color.
I did find this: http://www.experts-exchange.com/Software...
Hi
I want to place a lotus note link into a cell of an excel spread sheet so that when the userer clicks the cell content it opens a document link.
ie hyper link it to the lotus notes d...
Hi
I am writing code to loop through 100 rows of Excel and email a body held in each cell.
How do I make provision for different lines of a cell with multiple lines making up the body.
D...
Hi All,
first of all - sorry for my english - I am austrian - and thanks for your help.
Now my problem. One of my customers migrated 2 months ago from Office 2003 to Office 2007. A few week...
We have an Excel Workbook that we would like multiple users to have access to. I have set it as a shared workbook.
I am having issues where once so far the book has corrupted. I had to go t...
Hi there,
I would like to know how I would do the following.
I have an excel worksheet with formulas throughout it, and I want to retain all the values but lose the formulas, I tried copy an...
Hi -
Basic question: How can I iterate through the items in a Pivot Table report filter?
So lets say a pivot table contains a "Car Model" report filter with elements such as "Chevy", "O...
I have two columns of text and I need to find out whether any of the data from the 2nd column (5000 entries) exists in the first column (47000 entries).
But I also need it to tell me if it ...
We have an issue where we cannot get the highlighting to turn off in Excel. We have tried the common resolutions to no avail. (F8, right mouse click, control panel mouse settings). We have go...
excel 2007 : VBA
how to return a range of cells into an array?
ie, i have a few values in a sheet say in A1:A10 cells, how can I get them in a array, as if I was using array(cellA1, cellA2.....
Scenario: I receive daily a file of the past 60-days financial data, each day the oldest drops off and the newest is added. I have a macro that copies that date into a master file but have t...
I am receiving several errors when any add-in is loaded in Excel 2007...
The errors are as follows:
"System Error &H80004005 (-2147467259). Unspecified error."
"Out of memory"
"Com...
Hello -
I am having a problem getting a pivot table to sort date type columns correctly.
I am starting with a worksheet that has 4 columns:
Rep Text
FormType Text
Completed Short Date
...
I am using the following formula (=LEFT(A1,4)&"-"&MID(A1,5,4)&"-"&MID(A1,9,4)&"-"&RIGHT(A1,4) to convert 16 digit numbers to credit card format, adding a hyphen and not padding after the 15th ...
I would like a macro which inserts a text box within a spreadsheet at a specific size.
I have a simple userform, with a list of TextBoxes. I would like the texboxes to display a certain Cell value when the userform opens up. Then the user can change the value of the textbox and ...
How do you Open an Access .mdb file from Excel using VBA?
I have made an Excel 2003 workbook with some VBA programming.
The programming is very basic. What it does:
- It gets data from one sheet
- Creates a pivottable from this data
- Creates som...
Hi
I have a workbook with 2 sheets -- event and chart.
Event contains EventID, EventDate, ChartID,IncludeLabel and Label.
I want to create a chart template which will add Event.Lab...
I want to navigate throuhg few web pages.
Starting with the url:
https://www9.nysdot.gov/CSSWebView/CSS/Reports/ActiveFirmsRep.do?action=getFirmActiveStatus&reportFirmID=286
then click o...
