Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a cell in a row just inserted in a range.
I'm trying to select a cell in column 2 of a row that is just inserted into a
range using a macro. After searching the group discussion, I found and modified this script to actually insert the row. I now need to modify it to select the cell (make it active) in column 2 of the row that was just inserted. This macro is started with a button and the active cell could be anywhere when the button is pressed. Here's the code I'm starting with to insert a row: Dim DGrng As Range Set DGrng = Range("DG") Set DGrng = DGrng.Rows(DGrng.Rows.Count) Sheets("Preliminary Report").Unprotect DGrng.EntireRow.Insert Sheets("Preliminary Report").Protect Thanks in Advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting the first cell of the last row in a range | New Users to Excel | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Selecting a cell in a range | Excel Worksheet Functions | |||
Selecting a Cell inside a range | Excel Programming | |||
Selecting a cell range | Excel Programming |