Microsoft Office Forums - View Single Post - [Solved] Code looks like it should work, but don't

Thread: [Solved] Code looks like it should work, but don't

View Single Post

Old

02-22-2017, 10:25 PM

FUGMAN

FUGMAN is offline

FUGMAN uses Windows 10

Windows 10 FUGMAN uses Office 2016

FUGMAN uses Office 2016

Office 2016

Banned

The original poster

Join Date: Feb 2017

Posts: 55

FUGMAN is on a distinguished road

Default

Code looks like it should work, but don't

Baffled why the following code doesn't work.

ActiveWorkbook.Sheets("XXXX ").Activate
Sheets("XXXX").Select
ActiveSheet.Range("A7").Select
ActiveCell.EntireRow.Insert

Thanks in advance for any explaination

Reply With Quote