Code looks like it should work, but don't

NoSparks · #6 02-23-2017, 09:56 AM

I'm not able to setup anything that will produce that error. My gut feeling was merged cells could cause this, but apparently not.
Googling seems to indicate others with 'Method of range class failed' errors manage to eliminate the error issue by not using .Select, which is seldom necessary anyway. In your case

Code:

Sheets("XXXX").Range("A7").EntireRow.Insert

would suffice. Don't know if this will help or not, it's just a thought.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code doesnt work properly	ksigcajun	Word VBA	6	04-06-2015 07:41 AM
Can't make code work.	gbaker	Excel Programming	2	07-13-2012 10:01 PM
Will VBA code work in a web browser?	PeligrosoBlanco	PowerPoint	1	03-28-2012 11:57 PM
My Product code doesnt work!!!! PLEASE HELP	dukquaknoobhack	Office	1	01-05-2012 03:43 PM
simple code doesn't work help	piper7971	PowerPoint	2	08-19-2010 08:15 AM