dcsimg

Search:

Type: Posts; User: mkshehata

Search: Search took 0.02 seconds.

  1. Replies
    0
    Views
    244

    MsOf365 Excel Array formula not working!!

    I have list of countries (column B), names (Column Y), date of birth (Column S)
    For each country, I need to get oldest person date of birth and his name. I got the Max birth date correctly .. but...
  2. MsOf365 Excel 365: Missing Microsoft MonthView control 6.0 (SP4)

    I'm using Microsoft Excel 365
    I cant find the [Microsoft MonthView control 6.0 (SP4)] tool in More Controls list.

    I tried the following steps:
    >>Download the MSCOMCT2.OCX
    >> copy MSCOMCT2.OCX...
  3. MsOf365 Re: Excel 365: How to get Min & MAX of values mixed numbes & text

    Yes I have MAXA and MINA .. both return zero
  4. MsOf365 [RESOLVED] Excel 365: How to get Min & MAX of values mixed numbes & text

    I have a column list of Fiscal Years formatted as follows:

    FY19
    FY21
    FY18
    FY15
    FY30
    FY28
    FY29
  5. MsOf365 Re: Excel 365: How to pick every name once only from a list?

    Thanks a lot .. It works
  6. MsOf365 [RESOLVED] Excel 365: How to pick every name once only from a list?

    Hope there is a solution for my problem.
    I have a big list if names in column A from “Sheet1”, most of these names are repeated more than once. I need to create a function in different worksheet...
  7. MsOf365 Re: Application.OnKey not working in a do-loop

    Now it is working .. thanks a lot for your support.
  8. MsOf365 Re: Application.OnKey not working in a do-loop

    When I run this code, I received the following message:
    Cannot run the macro "......'!myend'. The macro may not be available in this workbook or all macros may be disabled.

    Even though my...
  9. MsOf365 Re: Application.OnKey not working in a do-loop

    I tried adding myselection = 0 after each procedure .. but still not working. I'm not sure if I've understood you correctly .. please see below:

    Private Sub CommandButton1_Click()
    Dim MySelection...
  10. MsOf365 [RESOLVED] Application.OnKey not working in a do-loop

    Hello,
    This is my first try to use Application.OnKey
    Would someone please help me in the following code. I have a command button on Sheet 1 the following is supposed to work, but it does not!!

    ...
  11. Optimized average of 4 groups of measurements

    I have 24 measurement values; I need to divide them into 4 optimized groups (6 measurements in each group) on condition that, each group average value has a minimum deviation from the total 24...
  12. Replies
    1
    Views
    423

    MsOf07 Copy rows from one sheet to another one

    Dear Guys,
    I'm using the below sub to copy some rows from a sheet to another one .. this is repeated hundreds times in my procedure. Is there any way to do the same without activating and selecting...
  13. Re: How to make Footer Page Numbering to continue from previous sheet

    Thanks a lot dear GBeats and dear westconn1 for your help .. I'll try both ideas and use the working one :-)

    Best regards,
    mkshehata
  14. [RESOLVED] How to make Footer Page Numbering to continue from previous sheet

    Hello Guys,
    I’m using the below VBA code to put (Page # of Total pages) in the footer of “Sheet1” and the same for “Sheet2”.
    How to write a code to make “Sheet2” continue numbering after “Sheet1”...
  15. MsOf07 VBA code to Copy picture from one worksheet to another

    Dear Guys,
    I have 4 pictures inserted in a Worksheet, I need a VBA code to copy a specific one of them and past it in different Worksheet in case my condition is True.

    Can anyone help me...
  16. MsOf07 How to obtain file name without file path using VBA

    Hello Guys,
    I'm using the below VBA code in Excel 2007 to allow end user to select a name and locate of an Excel file, then I will add some data to it.
    The problem is the file name...
  17. MsOf07 Re: Keep the name & path of user saved file using VBA

    Thanks a lot TnTinMN
    You solved my problem


    Best regards,
    MK Shehata
  18. MsOf07 [RESOLVED] Keep the name & path of user saved file using VBA

    Hey Guys,
    Just wondering if anyone knows how to do the followings using VBA in excel:

    By clicking a Command Button, a new excel file to be created and the end users to be able to save the file to...
  19. Re: [RESOLVED] How to clear a range of cells in a specified worksheet

    Thank you very much .. this is working
  20. [RESOLVED] How to clear a range of cells in a specified worksheet

    I'm using VBA in Excel 2007 and I need to clear a range of cells (to be defined by variables) in a specified worksheet.
    Can anyone let me know why the following syntax is not working and creates...
  21. MsOf07 Re: Passing an Arrays With Functions using VBA

    Thank you so much dear TnTinMN
    you solved my problem :-)
  22. MsOf07 [RESOLVED] Passing an Arrays With Functions using VBA

    Hello,
    I'm using VAB in MS-Excel Ver. 2007
    I have a problem of passing arrays to a function. Once I try to excute the code, I receive the following error message:
    "type mismatch: array or...
Results 1 to 22 of 22



Featured


Click Here to Expand Forum to Full Width