Search:

Type: Posts; User: Admin

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. Thread: Excel Wordle

    by Admin
    Replies
    1
    Views
    2,031

    Excel Wordle

    Hi Guys,

    I have created the Wordle game in Excel. It's not exactly the same as the original one. But I tried my best not to lose the spirit of the game.
    You are free to change the code to make it...
  2. Replies
    4
    Views
    1,810

    try For i = 1 To...

    try


    For i = 1 To ActiveWorkbook.Sheets.Count
    Set xRg = Sheets(i).Range("H10")
    Set xShape = Sheets(i).Shapes.AddPicture(xPath & xFiles(i - 1), True, True, xRg.Left, xRg.Top,...
  3. Replies
    4
    Views
    1,810

    Hi try this Sub InsertPic() ...

    Hi

    try this


    Sub InsertPic()

    Dim I As Long
    Dim xPath As String
    Dim xShape As Shape
  4. Replies
    1
    Views
    2,024

    Hi Welcome to board! not sure, but does...

    Hi

    Welcome to board!

    not sure, but does this make any good ?


    Dim r As Range

    Set sSelect = Selection.SpecialCells(xlCellTypeConstants)
  5. In D2 and copied down, =LEN(B2)>0 Now use;...

    In D2 and copied down,

    =LEN(B2)>0

    Now use;

    =CONCATIFS(C2:C11,";",D2:D11,TRUE)
  6. In the VBE window, Go to Insert > Module

    In the VBE window, Go to Insert > Module
  7. Replies
    3
    Views
    1,602

    Unfortunately, the current format doesn't help to...

    Unfortunately, the current format doesn't help to create the pivot.
  8. Where did you put the code? The code should go...

    Where did you put the code? The code should go into a standard module.
  9. Replies
    3
    Views
    1,602

    If you layout the data in a structured format,...

    If you layout the data in a structured format, then a Pivot table would do the trick for you.
  10. Hi You could try this UDF. Use it as ...

    Hi

    You could try this UDF.

    Use it as

    =CONCATIFS($C$2:$C$50,", ",$A$2:$A$50,F$1)

    or
  11. Replies
    4
    Views
    6,406

    That will be your unpivot column range which is...

    That will be your unpivot column range which is D1:I1

    HTH
  12. Replies
    1
    Views
    996

    The other link ...

    The other link

    https://www.mrexcel.com/forum/excel-questions/1034781-find-replace-text.html
  13. Thread: Selection range

    by Admin
    Replies
    3
    Views
    1,406

    Works only on ActiveSheet may be.. With...

    Works only on ActiveSheet

    may be..

    With Sheet1
    MsgBox .Range(.Cells(4, 5), .Cells(.Rows.Count, 5).End(3)).Address
    End With
  14. Thread: Time Counter

    by Admin
    Replies
    10
    Views
    2,429

    You are welcome! Dim TotHours As...

    You are welcome!


    Dim TotHours As Double
    Dim rngData As Range
    Dim CutOff As Double

    CutOff = 8
    If Application.WorksheetFunction.Weekday(DTPicker1, 2) = 5...
  15. Thread: Time Counter

    by Admin
    Replies
    10
    Views
    2,429

    Use this code. You don't need to create a sheet...

    Use this code. You don't need to create a sheet each time for calculation, instead use application.worksheetfunction.


    Dim TotHours As Double
    Dim rngData As Range

    With...
  16. Thread: Time Counter

    by Admin
    Replies
    10
    Views
    2,429

    keep 10 rows of data, zip the file and upload.

    keep 10 rows of data, zip the file and upload.
  17. Thread: Time Counter

    by Admin
    Replies
    10
    Views
    2,429

    Hi Mnet, Welcome to board ! Can you please...

    Hi Mnet,

    Welcome to board !

    Can you please attach the workbook ?

    Cut down the data if it's huge in size.
  18. See http://www.xl-central.com/blog.html

    See http://www.xl-central.com/blog.html
  19. @ Rob, Please use code tags while posting...

    @ Rob,

    Please use code tags while posting code. I have added the code tag for you this time.

    try


    Worksheets.Add before:=Worksheets("SpecificSheetName")
  20. It's an elegant solution ! Usually we propose...

    It's an elegant solution ! Usually we propose this way to handle 3d formulas.
  21. you don't need to upload all the data. keep first...

    you don't need to upload all the data. keep first few rows of data and delete rest. wanted to see the format of each sheet.
  22. For English version, replace ; with ,

    For English version, replace ; with ,
  23. Hi Rob, Welcome to board ! First question...

    Hi Rob,

    Welcome to board !

    First question why you use different sheet for different month ? Don't you use a single sheet for all data by adding a column for month ? which will make your...
  24. Replies
    3
    Views
    1,473

    Hi Dave, Please have a look at this...

    Hi Dave,

    Please have a look at this http://www.xtremevbtalk.com/tutors-corner/168296-lotto-algorithms-permutations-combinations.html
  25. Replies
    0
    Views
    5,414

    Showing progress bar in a status bar :)

    Hi All,

    A nice trick to display the progress on Application.StatusBar :)


    Option Explicit

    Sub ProgressBar()

    Dim i As Long
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4