excel prompted this error msg intermittently when scrolling, sometimes it hangs after that, how to solve this problem?
I have a spreadsheet with columns as the categories for data (i,e. name, position, status, ect.). I would like to highlight the ROWS in red that have "No" in column H and highlight the ROWS i...
I need a function that will take an entire cell value in Excel and convert the value into its MD5 hash equivalent in a new cell. I have seen several comments about using VBA or other software....
I have a user form with multiple cascading combo boxes. I want to store the data for these combo boxes on another spreadsheet within the workbook
The problem I am having is that the form da...
We have one copy of office 2007. Evryone else is using office 2003. We are seeing extreamly slow file opening in the office 2007, about 1-2 minutes. Files are on the server (server 2003) Offic...
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...
Hi all,
Would someone mind expanding on the VBA Evaluate function? I've seen it posted as a solution several times by a number of participants, but I'm still a bit unclear on the implementa...
I need to compare two worksheets and find the missing values and matching values between two sheets. I couldnt find the formula.
I need only to compare columns A in both with each other. Whi...
I have a user who created a new folder on a W2k server (he is using W2k Prof., Office 2k), then created an Excel document within that folder and saved it. He then contimued to work onthe file...
Hi,
I found a solution for converting text in a given cell to ALL CAPS using the UCase function as such:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range(...
I have a series of userforms that allow the user to manipulate and run analysis on their workbook. They are shown modeless in order to allow the user to access the data while the form is open...
I want to save my xls file using a custom delimter. I want to do the same thing that saving as a csv, tab-delimited, or space-delimited file does, but using an arbitrary character (or series o...
I have an excel spreadsheet with about 300 lines in it, each with a hostname on it.
I want excel to do an nslookup on each host and make a cell next to the hostname the IP address that is r...
I get the follwoing error when trying to open a .wk1 file in excel 2003 You are attempting to open a file type that is blocked by your registry policy settings.
We have wk1 files all over ...
This is a very interesting issue. I have a client that has Office 2007 Pro on Windows XP Pro SP2. Word and Excel work fine except he is unable to save documents to a network drive on a 2003 se...
Hello all.
I need to count the number of characters in a cell. I say characters because the field contains numbers (formated as text, because of leading zeroes) and a dot.
So you have a...
Hi,
Any way to stop a macro running.
I have macro that get data from the machines directly.They take a long time.Some times if i need to stop the macro running i cannot .I only have to clo...
Hi experts...
Firstly, I have an access database which contains some forecasting data.
We are trying to use an excel pivot table linked into the access databse (data import external data, im...
Hi.
I'm using a macro that emulates the "advanced filter" command, so that when a button is pressed, a block of data is filtered, depending on various criteria, which is dynamic (i.e. it can...
SITUATION:
i use this set of macro to copy in clipboard many outlook links, or one only and i end up with the same problem as tlt28gvg121 (See code snipet, sry for the french comments)
i pas...
While trying to send a message from Outlook, Excel (which was running but minimized) popped up and error message reading:
Microsoft Excel is waiting for another application to complete an O...
Dear All,
I have a batch file (.bat),What I want is from excel macro write a command to run this batch file.
I created a macro and stored it in my Personal workbook so that it could be accessed from any workbook. However, I need to either edit or delte the macro as it does not work properly. Howeve...
I have an Excel spreadsheet form that is filled out be various users. They will provide information in columns A and B. I would like to create a macro (or something) that will query an SQL dat...
I need help to modify my Excel formula. This is what I want my formula to do:
1. If F16 and E16 is empty, G16 = " "
2. If F16 > E16, G16 = "F16 is bigger"
3. If F16 < E16, G16 = "E16 is big...
