ExcelBanter - shift the cursor down 2 rows please.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - shift the cursor down 2 rows please. (https://www.excelbanter.com/excel-worksheet-functions/90457-shift-cursor-down-2-rows-please.html)

Steved

shift the cursor down 2 rows please.

Hello from Steved

With the below macro how could I shift the cursor down 2 cells please.

Sub Broken()
Selection.EntireRow.Insert
ActiveCell.Offset(1, 0).EntireRow.Copy
Cells(ActiveCell.Row, 1).PasteSpecial
End Sub
Thankyou.

Ryan Poth

shift the cursor down 2 rows please.

Steved,
Try
ActiveCell.Offset(2, 0).Select
HTH,
Ryan

"Steved" wrote:

Hello from Steved

With the below macro how could I shift the cursor down 2 cells please.

Sub Broken()
Selection.EntireRow.Insert
ActiveCell.Offset(1, 0).EntireRow.Copy
Cells(ActiveCell.Row, 1).PasteSpecial
End Sub
Thankyou.

Steved

shift the cursor down 2 rows please.

Thanks Ryan.

"Ryan Poth" wrote:

Steved,
Try
ActiveCell.Offset(2, 0).Select
HTH,
Ryan

"Steved" wrote:

Hello from Steved

With the below macro how could I shift the cursor down 2 cells please.

Sub Broken()
Selection.EntireRow.Insert
ActiveCell.Offset(1, 0).EntireRow.Copy
Cells(ActiveCell.Row, 1).PasteSpecial
End Sub
Thankyou.

All times are GMT +1. The time now is 09:06 AM.