+ Reply to Thread
Results 1 to 2 of 2

Need to use the Fill Handle in the current active cell

  1. #1
    Registered User
    Join Date
    02-03-2022
    Location
    London
    MS-Off Ver
    Windows 10
    Posts
    1

    Need to use the Fill Handle in the current active cell

    Hi,

    Below is some code I have made in excel that checks a cell for a value and if there is a value then it inserts a new row and goes back to the previous blank cell. What I need to do from here is use the fill handle in the active cell to drop down the coding and then go back to the original IF statement to check if there's a value in the active cell and repeat. This is the bit I'm struggling with, I can't figure it out.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Need to use the Fill Handle in the current active cell

    Not sure what it is that you actually want to do - a before and after view of a few rows would be helpful. VBA doesn't really use the fill handle, but there are many ways to fill cells...
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code to disable fill handle and cell drag & drop for specific worksheet only
    By Dbroek in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-03-2020, 04:24 PM
  2. [SOLVED] copy and paste in current active cell, and need current date then scroll down 140 lines
    By vengatvj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2013, 03:40 AM
  3. VBA - Can I select a new active cell based on the value of the current active cell?
    By GrumpyOldBastard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2012, 07:05 PM
  4. Link active cell to scrollbar and handle percentages
    By Cjax in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-07-2011, 02:03 PM
  5. Replies: 4
    Last Post: 08-13-2011, 05:51 PM
  6. Replies: 4
    Last Post: 04-21-2006, 12:25 PM
  7. [SOLVED] Can you change the function of the fill handle on a cell in Excel
    By AndreaRaRa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2006, 12:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1