• MVP Logo
  • Recent Forum Posts

    smippen

    Hide rows based on drop down box selection

    Normally I would do my research or read my text book to learn about the answer I need but I do not have the time.
    I think what I need is fairly...

    smippen Today, 02:59 PM Go to last post
    p45cal

    Copy paste into dynamic column

    Code:
    Columns("K:K").Insert
    With Intersect(Columns("C:C"), ActiveSheet.UsedRange)
      .Offset(, 8).Value = .Value
    End With
    ...

    p45cal 2020-04-08, 11:57 PM Go to last post
    ges

    extract data from web

    Hi, try this

    Code:
    #If VBA7 Then
    Public Declare PtrSafe Sub Sleep Lib "Kernel32" (ByVal dwMilliseconds As LongPtr)
    #Else
    Public
    ...

    ges 2020-04-08, 09:35 PM Go to last post
    Lolbert

    Copy paste into dynamic column

    Sorry for posting prematurely, but I solved it.
    Probably far from the best solution, but it does the trick for me:

    Code:
            Columns("K:K").Select
    ...

    Lolbert 2020-04-08, 07:09 PM Go to last post
    Lolbert

    Copy paste into dynamic column

    Hi

    I have this simple VBA code where I run a macro to copy a selection and paste it on a new selection.
    What I need is for the code...

    Lolbert 2020-04-08, 06:53 PM Go to last post