• MVP Logo
  • Recent Forum Posts

    p45cal

    Please help!

    Aagh. Beaten to it!
    Power Query solution at cell H10.
    Update the data in the table at cell A1 then right-click the result table and choose...

    p45cal Today, 11:27 AM Go to last post
    alansidman

    Please help!

    A Power Query solution:

    Code:
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Unpivoted Columns"
    ...

    alansidman Today, 10:39 AM Go to last post
    cprop76

    Thanks, sample attached!

    Thanks, sorry for the VERY late reply, I've been out of the office all week. I've attached a sample which hopefully makes sense! The left hand side is...

    cprop76 Today, 03:41 AM Go to last post
    p45cal

    Check cell format is Date ignore blank cells

    try:

    Click on the picture to get a clearer view.

    Oops, fotrgot the code:

    Code:
    Private Sub DateFormat()
    Dim myRange As Range
    ...

    p45cal Yesterday, 03:01 PM Go to last post
    RET

    Check cell format is Date ignore blank cells

    Try this

    HTML Code:
    Private Sub DateFormat()
       Dim myRange As Range
       Dim Celda As Range
       
       Set myRange = Range("B2:B14")
    ...

    RET 2020-11-29, 09:24 PM Go to last post