Hi All,
If I have an array of random un-sorted values, is there a way that I can quickly sort them (i.e., Array().sort)? Is it possible to use this method on a multi-dimentional array by ...
Using a macro\VBA want to read the color of a range of conditional cells and change some referenced objects to the same color. I have shapes of states and want to change the color based on th...
Hi
I have Excel VBA code which I built in Excel 2003, in which I use the Split function.
I want to use the code on an earlier version of Excel, in which the split function
doesn't seem to...
I am trying to write the vb code to clear any and all excel applications which may be running on the PC.
I have the following but keep getting an error when it goes to close out the second a...
I have two excel spreadsheets. One is a list of customers with their names and addresses and id numbers (unique for each customer). The other is a list of items the customer bought with ea...
Hi guys,
I'm looking for help with an Excel formula - here's what I need to do:
I am a teacher and want to track student attendance using an Excel sheet that calculates percentage attend...
I have been using the Excel 2K on one of my computers for two years. Today when I launch Excel I see my user name registered in the opening flash screen...then I get the spreadsheet open but t...
I've a sheet with a date colimn. Being a lazy SOB, I've grown tired of entering the a date for every new row I add.
Is there a way to, whenever a cell in that date column gets focus, to po...
How do I implement the following logic in VBA:
If Cell A1 >= Cell A2 Then
Change Color Of Cell A1 To Red
Change Color Of Cell A1 To Red
End If
- I want this triggered by num...
I need to take a number in an Excel cell such as 10.40 and have it print on a check as Ten & 40/100. Is this possible in Excel 2007? Thanks!
I can't believe this is so hard. I think I've seen 100 answers on EE to this exact question and I still can't figure it out.
I have a SQL Server database with a table called Branches. I w...
I have a macro that creates a separate workbook for each of my accounts. Each account can have up to 10 different sets of contact details. Each workbook contains buttons that allow the user to...
How can I convert hh:mm:ss to decimal hours for applying labor rate? I'd need to go to four decimal places for accuracy. For instance, a typical labor entry from my database indicates start ti...
Hi there
Can anybody give me a piece of code that merge adjective two cells into one?
Using Merge function in Excell wipe away the data of right side of the cell.
I don't want to loose le...
I am consistently getting a "Cannot empty clipboard" error in Excel 2007 after a drag and drop. Copy and paste does not produce the error. The same error ocurs using Excel 2007 on both my Vi...
I'm sitting in cell A1. Cell B1 has a date and Cell C1, C2, C3, C4 all contain different dates. I want to say the following
if B1 is between C1 and C2, cell A1 will be red
if B1 is betwe...
Excel 2003 when I put in the number 160147963955 excel it automatically changing it to 1.60148E+11
I don't know how this happened and don't know how to change it back. Thanks.
This should be an easy question, but I am new to Excel coding...
I have a range of cells (all in one column), which I want to append some extra text to the end of each cell. How should I d...
In Excel when a document is closed a .tmp file is left behind in the folder, these files have to be manually removed instead of Excel removing them when the file is closed.
The user and Sys...
Anyone have code to sort an Excel sheet by column? The top of the column has company names and I want them arranged a-z keeping all of the column data in place. For example:
DEF Co ABC ...
I am using the End xldown command to activate a range. I first search for text in a cell, the header, and then offset down one row to get to the first cell in the range I want to activate. M...
What are the ways to remove leading and trailing whitespace in cells?
Not sure if this is even possible. To calculate a date difference between two cells in Excel a formula such as this will work:
=DATEDIF(A1,NOW(),"d")
But what if you are calculating for ju...
In Excel I have created several procedures (macros) that manipulate ENTIRE columns of data, even though I may only have a several hundred rows of data that contain any data. I think this is ...
I have a user who has a spreadsheet already setup with positve and negative numbers. This user would like to flip flop all the numbers - positive to negative and vice versa.
He knows how t...
