find a non-empty cell
Dear experts, what is the quickest VBA way to determine in a big cells range if at least one of them is non empty? Many thanks for your help! Best regards -- Valeria ... 29 Apr 2010 11:15
Check to see if subtotal is expanded
I've had a quick search and couldn't seem to find anything on this so hopefully you can help :) I have a spreadsheet with a number of subtotals with a second tier. I also have a button to add a new sub task to a tier 1 group. For example: Task A Sub Task a.1 value Sub Task a.2 value Task ... 29 Apr 2010 10:08
Array problem? List comparison?
Hey, Let me set up what I'm trying to do. I have 3 columns with the following data. A: 10, 20, 30 B: X, Y, Z C: 28, 8, 1 Now, I have a last column, D, which I'm trying to figure out the correct formula for. I want D to return the following: Look at column A, find the smallest number that's greater than... 29 Apr 2010 03:31
Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!
On Apr 28, 11:01 pm, Dave Peterson <peter...(a)verizonXSPAM.net> wrote: xl2007 still supports the old syntax. So you could create the macro (record it???) in xl2003 and it'll work ok. This may help (or not!): Dim wks As Worksheet Dim myRng As Range Set wks = Worksheets("Sheet9999")... 29 Apr 2010 08:59
Compare two lists and get differences
Hi, I have two files: FileOrigin and FileDest. I execute a Macro in FileDest, and select the FileOrign with Application.Dialogs(xlDialogOpen).Show. 1) FileDest as a unique ID in sheet Track, cell AQ7. This is text and numeric (example IFS-gs21e3). Also has a list of Providers in range C84:C133. (text and numer... 29 Apr 2010 06:46
Tweak to display autoshape
Seeking a tweak to the sub below. Currently it displays "txt1" aligned with the top edge of the selected cell, just to the right of it. Unfortunately this position obscures immediate cols to the right of the selected cell, which user occasionally needs to see. I want to "push" the display vertically down a bit ... 29 Apr 2010 05:41
How do I create a hyperlink with a macro?
Hello, I am attempting to create a spread sheet for work that is as easy to use as possible. My goal is to create a macro that adds a hyperlink to a particular cell. The catch is, I would like the URL to come from the clipboard. This way all they need to do is copy the address and run the macro. Is this possib... 28 Apr 2010 20:53
Pop up message asks if I really want to edit the live office data
I have macros running in excel which massage data created by Live Office (Business Objects Queries.) With most popup messages I just use the displayalerts statement to get around it. That does not work for this message which specifically addresses the Live Office edits. Does anyone know how to suppress it. ... 28 Apr 2010 19:45
Sort Worksheets Numerically
I have workbook with 250 sheets and I need to sort them by the total sales on each sheet. My first thought was to rename the sheet to the sales value (e.g. Customer ABC111 had sales of $4,000, so the worksheet name is now 4000). That part worked fine, but when I use any sorting code, it sorts the sheets in ... 28 Apr 2010 19:45
names in file name
Can I create a file name from Names or Named Ranges in a workbook? If there are Names BorrowerName, LoanNumber, ReviewDate, in the WB, can I do this: ThisFile = BorrowerName & LoanNumber & ReviewDate & ".xls" Application.Dialogs(xlDialogSaveAs).Show (ThisFile) or something like that? ... 30 Apr 2010 09:29