Search results

Every row in column A is the result of the corresponding row in column C - the corresponding row in column B. If the result is not 24 I want to display a message box. Only one row is completed each time. Only the message box has been clicked the result of the calculation can stay. The box only...

Dears I have below formula =OFFSET($D$4;1;0;COUNTA($D$5:$D$11)-COUNTBLANK($D$5:$D$11)) for a dynamic chart which works fine except when there is no data. When there is no data I have one column with value one and an error message saying "A formula in this worksheet contains one or more invalid...

Dear all Could somebody help me with below? I have a combobox and when I select one of the values from the drop down list it remains highlighted in blue. It only becomes not highlighted again when I click any other cell. For the rest it works fine. I played around with the properties but no...

Hi I've got below code (based on the recording of a macro) which filters 2 pivot tables on basis of the input of a cell and then sorts the pivot tables in ascending and descending order. The code works unless there is no data in either of the pivot tables. Can anybody please help me improve the...

Hi How would I indicate to execute a macro when cell b3 in a worksheet has changed. B3 is linked to another cell in another worksheet Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" ( here i want to say has changed) Then run macro end sub Any help would...

Hi I've got a command button in excel 2007 that leaves an imprint after you've pushed it. The imprint disappears after you click any other cell. Otherwise the command works fine. Anybody any ideas how to remove the imprint automatically? Any help would be much appreciated!

Hi Can you add a label filter to a report filter in a pivot table? I'm trying to use a wild card to retrieve the top 10 for for example "????A". The input "????A" would come from a cell in another sheet. So far I managed to get below code Sub wildcard() ' ' wildcard Macro ' '...

Hi I sumifs'ed for these values Apples Oranges Pears Kiwis Bananas Peaches and now I would like to sum all others which are none of the above. I can manage one with eg adding "<>Apples" but i can't manage more than one. Any suggestions anyone? Any help would be much appreciated!

Hi I'm trying to put a hyperlink to a hidden sheet but doesn't work with below. Any suggestions anyone? Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Worksheets("Oranges Sold").Visible = xlSheetVisible Sheets("Oranges Sold").Visible = True Sheets("Oranges Sold").Select...

Hi I'm trying to use ""*$" in a concatenate function but excel does't accept this. The problem seems to be with the second " after the first one. Excel accepts '' but then this does not work for the sumifs. complete formula is...