#1
|
|||
|
|||
Way to autoshift cells down
I am building a sheet in which I would like to input a value under the verify value space, green cell, and then when i hit enter the value i entered to shift down. Ultimately the values i enter will verify with values under values 2 cell, red cell, but I am already aware of how to do this. Thanks in advance! |
#2
|
|||
|
|||
Here is one method :
Paste in the Sheet Level Module : Code:
Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("G2").Value <> "" Then Range("G2").Insert Shift:=xlDown End If End Sub |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting table to text (and back) with carriage returns in cells, split and merged cells | ndajko | Word | 5 | 11-04-2019 07:53 AM |
Borders on merged cells also appearing on unwanted adjacent cells | MrsC | Word Tables | 2 | 08-19-2019 09:14 AM |
Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
Linking cells: can sub-cells move with their master-cell when sorting? | kw01 | Excel | 1 | 06-30-2015 05:02 PM |
Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |