Search:

Type: Posts; User: Michael M; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.43 seconds; generated 36 minute(s) ago.

  1. Replies
    1
    Views
    50

    Re: Marksheet formula

    Maybe this


    =IF(AND(COUNTIF(B1:D1,">="&K1)>1,COUNTIF(E1:G1,">="&K1)>=1,COUNTIF(H1:J1,">="&K1)>2),"Qualified","fail")
  2. Replies
    14
    Views
    116

    Re: VBA to insert a custom image

    whats the issue ??
  3. Replies
    14
    Views
    116

    Re: VBA to insert a custom image

    ONLY LIGHTLY TESTED
    you will need to play with lr in relation to where the picture goes.


    Sub MM1()
    Dim fNameAndPath As Variant
    Dim img As Picture, shp As Shape
    Set shp =...
  4. Replies
    13
    Views
    142

    Re: numbers to text and text to numbers

    What was it formatted as before you typed in 1234.0001 ??
  5. Replies
    14
    Views
    116

    Re: VBA to insert a custom image

    What is the relationship between txtbox 4 and the inserted shape ??
    Why not simply place the new image


    Sub MM1()
    Dim fNameAndPath As Variant
    Dim img As Picture, shp As Shape
    Set shp =...
  6. Replies
    13
    Views
    142

    Re: numbers to text and text to numbers

    Imagine having the number 1234.00001 in a cell.
    IF you don't need to apply any mathematical equation to it, but simply want it to appear as text for the visual result, converting it to text will...
  7. Replies
    14
    Views
    116

    Re: VBA to insert a custom image

    I think this is what you are trying to do ??
    At least it should get you started

    Sub MM1()
    Dim fNameAndPath As Variant
    Dim img As Picture
    fNameAndPath =...
  8. Replies
    14
    Views
    116

    Re: VBA to insert a custom image

    What is this Dave ??
    Are you copying and pasting Textbox4 or the picture "ImgJ" ??
  9. Re: Conversion of column list to comma delimited string

    Aww stop it, now you're just making me feel redundant..:oops:
    Thanks for the pointer.
  10. Re: Conversion of column list to comma delimited string

    Peter_SSs
    I'm ever impressed...:pray:
  11. Re: Conversion of column list to comma delimited string

    Try using


    Sub MM1()
    Dim i As Integer, s As String
    i = 1
    Do Until Cells(i, 1).Value = ""
    If s = "" Then
    s = Cells(i, 1).Value
    Else
  12. Replies
    6
    Views
    175

    Re: Minimizing utility

    OOps...didn't realise that..:oops:....like it though !!
  13. Replies
    13
    Views
    314

    Re: proper syntax for With Rng/Evaluate?

    I think you are also asking for problems, If you are assigning a number to a variable called "formula"
    Call it n, or x, or anything but using the word formula.
  14. Replies
    9
    Views
    151

    Re: Case "Question"

    Keeping in mind of course that you may / may not need to loop through the sheets.
    So, if you want to apply / or not, the code to activesheets it could simply be


    Sub MM1()
    Select Case...
  15. Replies
    9
    Views
    151

    Re: Case "Question"

    Ahh...you mean like this ??


    Sub MM1()
    Dim ws As Worksheet
    For Each ws In Worksheets
    ws.Activate
    Select Case ActiveSheet.Index
    Case 1 "sheet number
    'Do stuff
  16. Replies
    9
    Views
    151

    Re: Case "Question"

    you confused me...:lol:



    For Each ws In Worksheets
    ws.Activate
    Select Case (ws.Name)'this doesn't change !!
    Case "Name1" 'this changes to your required sheet name !!
    ...
  17. Re: Organizing Columns w/ First and Last Names

    Why don't you sort by last name first, THEN join the names ??
  18. Replies
    9
    Views
    151

    Re: Case "Question"

    Something like this ??


    For Each ws In Worksheets
    ws.Activate
    Select Case (ws.Name)
    Case "Sheet1"
    'Do Stuff

    Case "Sheet2"
  19. Replies
    6
    Views
    175

    Re: Minimizing utility

    Fluff.....Whats with the new Avatar...:biggrin:
  20. Replies
    6
    Views
    175

    Re: Minimizing utility

    Just by looking at you screenshot..it is Subtotals....Grouping and Ungrouping.
    Have a look here on methods and How To !!

    https://www.contextures.com/exceldatasubtotals.html
  21. Replies
    4
    Views
    66

    Re: Passworded Sheet is NOT protected

    I know the people you may be dealing with, and I doubt there would be any effort on their part...but, you are aware that sheet protection is very weak and can be easily broken ???
  22. Replies
    4
    Views
    66

    Re: Passworded Sheet is NOT protected

    Is the worksheet that doesn't protect the one that holds the password.
    Also, why not put the password into the code via InputBox....so ask the user for the password to Protect the sheets, if it...
  23. Re: How do you query in excel? What would be the best program to complete this in?

    All I can suggest is looping through the directory, extracting the relevent worksheet and putting them all into 1 workbook.
    You could then extract to a "Summary" sheet from there.
    there is a...
  24. Re: Combining cells from multiple worksheets into rows on single worksheet

    That's probably the best "Guess" I have ever had....:lol:
  25. Thread: Inquiry

    by Michael M
    Replies
    13
    Views
    531

    Re: Inquiry

    You may need to provide more info, but have a look at Autofilter for your "above 35"....that might also give you your consecutive instances
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4