Programming

Function Last Row()
Code below is by Ron de Bruin and will find the last row with anything in it. Function LastRow(Sh As Worksheet) On Error Resume Next LastRow = Sh.Cells.Find(What:="*", _ After:=Sh.Range("A1"), _ Lookat:=xlPart, _ LookIn:... 27 Oct 2009 13:40

Conditional Formatting in 2007
I have a pivot table that is linked to data in a project/resource management system. I want to apply conditional formatting so that I can (1) highlight project entries based on their current state, (2) format the total rows for each resource so I can highlight those that are over committed (total hours > 40) and th... 28 Oct 2009 12:55

Excel 2003 - Button moves along with the cell selection
Hi, I'm using Excel 2003-SP3. I have a button (Form button NOT a Command Button; I chose it from "View->Toolbars->Form" controlbox) placed in a worksheet. I also have a list in a few cells in the adjacent column which is populated from a Range of values defined in the same sheet. When I click on the cell... 24 Oct 2009 11:00

57 KewaSa.com DDL Torrents
www.KeWaSa.com DDL , GAMES, MUSIC, MOVIES,SOFTWARE www.KeWaSa.com Descargas Directa, Juegos Musica, Peliculas, Programas , Software xhzul+?soD(Ns_vJ=BkASUCyp ... 23 Oct 2009 07:47

Restrict Pivot Tables
Below is a sample of a pivot table that I'm trying to restrict. Found code on the web that allows me to do it but I'm having a problem Sub h_PT_Restrict_PivotTable() 'Restrict pivot table functionality Dim pf As PivotField With ActiveSheet.PivotTables(1) .EnableWizard = False .EnableDrilldown = False ... 15 Oct 2009 11:39

VBA using VLookUp
I have two workbooks open: book2.xls and Dept_IDs.xls I want to use VBA to determine if a value in cell A7 of Sheet1 of book2.xls needs to have its cell colored based on the 3rd column of data in a range named: Dept_ID_T in the workbook: Dept_IDs. IE, if the VLookUp([book2.xls]Sheet1!A7,[Dept_IDs_0911.xl... 12 Oct 2009 12:58

Excel 2003 - macro options grayed-out
Hi, in one file macro options button is active, in another the button is grayed-out. How to make that button always active? (I know there is other ways to assign a key shortcut programmatically like MacroOptions and OnKey methods, but they are not what I'm looking for) TIA ... 12 Oct 2009 09:34

Using Hyperterminal
I have a tag reading system that can stream data to hyperterminal. Is there a way to capture data that is going into hyperterminal and send it to excel in realtime. Thanks ... 12 Oct 2009 07:23

Get Tooltip Text, 3rd Party App
All, Has anyone ever tried to get the tooltip text from a third party application's button? (I'm working with an application called "Research Wizard," but the code works just as well for Internet Explorer). I'm willing to post the code (which is rather lengthy) if someone feels they can help (but please re... 9 Oct 2009 17:08

Formula Bar Hidden
Hi I have written a VBA code to hide formula bar in the Workbook open event. The code is : If Application.DisplayFormulaBar = True then Application.DisplayFormulaBar = False End if To bring the formula bar back once I exit out of this workbook, I wrote a code in workbook before close event and the code is... 8 Oct 2009 12:19