Re: How to do this with macro? Don 0 278
oops. to find the last number in b and subtract a1 =INDEX(B:B,MATCH(9999999,B:B))-A1 -- Don Guillett Microsoft MVP Excel SalesAid Software ...

Excel/Cellphone Charles 0 418
Hi, I would like to know if it's possible to program Excel to send Text msg to Cell Phones. ...

Floating text Utf 1 314
Hi everyone, I'd like to have some question+answer showing up on top of all my applications() to make me read it and memorize it. I know that I ...

Deleting Duplicate Rows Utf 11 262
Hi, I checked out the archives for close to an hour, but I couldn't figure out how to change the codes given there to suit my needs. I have a larg...

Macro if criteria Utf 2 301
Hi, i have two macros. (macro 1 and macro 2) I need macro 1 to run if in A1 is "JOHN", in B1 is "MARY" and if C1 is empty ; and macro 2 to run if i...

External Data from SQL Server Utf 1 294
I have a worksheet that is importing data from SQL Server. MS Query is configured to execute a stored procedure. Sometimes when I refresh the qu...

Code not working in a PROTECTED Worksheet Utf 2 297
I have the code below in a worksheet on a file in SharePoint. The worksheet is Protected so only unprotected Cells are selectable. The problem I am ...

VBA Code to select and format range Utf 2 464
Hi All, I want to select a range of cells and format the range of cells based on a "offset" feature... The last couple lines in my code are: ...

Save data before printing Saga 1 265
Hello all, An acquiantence is programming in Excel 2003 and has a sheet where theuser enters receipt data. When he is done, he clicks a boton to ...

Can use VSTO to reduce the size of a file? Utf 0 301
I have a really large spreadsheet that is saved in a sharepoint location but takes about five minutes to load. Would it make any difference if I ...