Programming

Testing object value
I am working on setting up some code to test whether an image is loaded in an image box: I use this to test to see if there is no image loaded: If Worksheets("Sheet1").OLEObjects("Image2").Object.Picture Is Nothing Then How would I write this line to test if there IS an image? Thanks! ... 6 Apr 2010 15:21

Macro to Find Column
I have several spreadsheet with a column for e-mail address. Some cells have two e-mail addresses. I need to separate the addresses so that there is only one address per cell, then delete the second address. This is easy to do using text-to-columns and I recorded a macro to do just that. The problem is that... 6 Apr 2010 14:12

Formula Question
I need to do some type of lookup and sum in vba I'd like to use Total Sheet.B5 to return the value Total Sheet.B5 to = 55 if Total Sheet.A5 = Orange Total Sheet A5 = Orange B5 = 55 Sheet 1 A4 = Blue b4 = 5 A5 = Green b5 = 10 A6 = Orange b6 = 15 Sheet 2 A4 = Orange b4... 6 Apr 2010 13:03

prevent a user from adding any sheet in a workbook
I have an excel workbook in which i don't want the user to add any sheets. I tried following code to delete the sheet every time a new sheet is inserted. However, Microsoft generates a message and user has to select Delete key every time and if the user presses cancel then a sheet is inserted. How can i automati... 6 Apr 2010 11:56

PivotTable 2003 Code is not working
HI guys, I have added code to show all items in my pivottable when a bitmap is clicked. The code needs to first show all items in the pivottable and then go back to the scorecard sheet. THe code to show all itmes does not work at all. The hyperlink works fine. I am hoping this code will solve another pro... 6 Apr 2010 11:56

Macro which delets in a cell all characters after comma
Hi guys ! I have a lot of cells with text , empty spaces etc . All cells contain a "," (comma) . I need a macro that delets all after that comma , including comma . I give in example : A1 : mother, father The result should be : A1 : mother Many thanks ! -- andrei ----------------------------... 6 Apr 2010 11:56

Change Default Hyperlink Browser..?
Is it possible to Change, the Browser that a hyperlink opens ..? I have I.E. but prefer Firefox, However Certain pages Will not open in FireFox, for some reason.. So i would like to change the Browser for certain Hyperlinks.. ...or can it only use the Windows Default for hyperlinks ..? (Suppose most like... 6 Apr 2010 11:56

Copypicture from Excel to PowerPoint
Hi, In a VBA routine a selected ranges in Excel (2003) is copied and paste in PowerPoint. The routine runs a loop with an number of entities. A number of rows and columns in the selected area are grouped on a lower level and only cells on level1 are visiblebefore CopyPicture.It works OK apart from one problem.... 6 Apr 2010 11:56

for loops
I am trying to create a macro from scratch that can tell me what value is the maximum value in a column of values and then what the value is in the cell to the left of that max value. I thought a for loop would work for the max value part but i dont know how to get it to do that last part. Any help would be g... 6 Apr 2010 16:29

Insert formula even cells with data below it
Using this code Sub Insertformula () For Check = 4 To 40000 Step 2 If Cells(Check, "b") <> "" Then Cells(Check, "b") = "=IF(OR(I5="",J5=""),"",NETWORKDAYS(I5,J5,Holidays!A$1:A$39)-1)" Next Check End Sub My objective is to put this formula =IF(OR(I5="",J5=""),"",NETWORKDAYS(I5,J5,Holidays!A$1:A$39)-1) ... 6 Apr 2010 13:03