• Other - General

    by Published on 2016-11-06 11:48 PM
    Article Preview

    Getting the Most From Excelguru Forums
    We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

    How the Forum Works

    Using the Forum
    Step 1 – Register, Activate Your Account and Log In
    Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

    1. Register
    2. Activate
    3. Login

    If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

    Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm that you’re a real person. ...
  • 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