The code attached will disable (delete) the Excel 2003 system menu, also disabling Size, Move, Close, Resize, Minimize. This happens in the first 6 iterations of the loop. I don't know what th...
This is the second time in my life I try to do something in Excel (as the expert in the family need to assist a student in a project) and
A) I get unexpected behaviour
B) Have no clue how to...
Does anyone know of a way to rename a file folder based on a cell value in excel 2007. I have several file folders with one spreadsheet in each one. I would like to rename the file folder base...
I have a spreadsheet that needs some data populated based on other data. The attached spreadsheet should give you the idea of what I need. I also need this done in VB since it takes up 30k r...
I am trying to create a production schedule but I cannot seem to find an efficient way to create the equation needed. I have tried to physically select all of the cells needed to complete the...
I've set up a form system for our company on Excel consisting of: a quote, a work order and a packing list. Each of these pages is a seperate worksheet in one workbook. I would like to be a...
I have a set of values I need to loop through and return. The number of these is variable. It looks as though the Evaluate function doesn't do what I was hoping it would.
Let's see if I c...
Hi,
Calculating 2 processors issue in excel
I have some codes that are used to do some task.
When i do use those macros or do a manual job like. Delete a row or add a row or any thing. Li...
I have an Excel External Data connection that works fine when I am logged on. However, I have Network and SQL server administrative security. Now I am trying to turn over the process of refr...
This one's a easy one for you guys. I just can't figure it out.
You don't need a sample workbook for this one :)
Content of B1 needs to be copied to C1
Content of D1 needs to be copied...
How can I check whether a worksheet has a used range or not?
When I retrieve the usedrange of a blank worksheet it returns the range "$A$1" which is not correct. If I use the usedrange prop...
How to set the internal exel file accosiation ?
By default excel opens an created hyperlink to a picture (assumming test.jpg) with internet explorer.
The general file accosiation hints to ...
How can I copy an excel workbook file using VBA code without opening the file?
I have two lists I am comparing to see if the value in column B matches the exact same value in column A with the exception of uppercase or lowercase.
What I want to do is simply highligh...
Hello,
I have several .xls files (I have 2007, these just happen to be xls) that I would like to remove some text from. Each workbook has column A labeled LID and then each cell in that colu...
If I open the Excel 2007 shortcut (not by opening a file) it starts with a blank worksheet in [Compatibility Mode]
Is there a way to make Excel 2007 start in native mode instead of Compatib...
In Excel 2003, from the VIEW menu, Header Footer menu option, on the Header/Footer tab, the drop-down menus for the header and footer... (see attached .bmp file for screen shot of what I'm re...
In Excel, I have 4 years worth of data in USD amounts in columns like this:
Date Earnings Expenses Profit
MM/YYYY $x, xxx $xxx $x, xxx
I would like to be ab...
Assume
A1 abc.com
A2 xxx.com
A3 test.co.uk
A4 hello.org
B1 xxx.co.uk
B2 hello.co.uk
i wish to compare B column with A column.
If first few characters of B column match A column t...
Hello,
Is it possible to output equation(s) and R-squared value(s) from an Excel scatter plot to a new worksheet. It'd also be nice if there was some sort of notation in the output relat...
As refer to the uploaded image below, how can I count and sum the appearance of dates in column Date 1, Date 2 and Date 3?
If the date appears at column Date 1, Date 2 or Date 3, it counts....
Hi EE,
=================================================================
Please see the screen shot below to see how nice the graphs look as 2 rows....
=====================================...
This may be more of a Windows question, but I have a spreadsheet that contains several hyperlinks to files that have a pound sign in their name. As such, the link doesn't work. Once you remo...
Experts,
I want to use the "track changes" feature in Excel 2007, as explained pretty thoroughly in this tech tips article:
http://www.online-tech-tips.com/ms-office-tips/track-changes-in-ex...
I need the below code to run and at the end UNhide the selected cells (columns).
Basically, you click a command button and it hides 35ish columns,
then selects cells in a row that conatin...