View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default InsertRowsAndFillFormulas

Leslie,

As you should have, since I was brain-dead <g.

Simply change the word Range to Cells: i.e., change

Range(65536, .....

to

Cells(65536, .....

Sorry about that,
Bernie



"Leslie Barberie" wrote in message
...
I made the code change and I'm getting Run Time Error 1004 - Method Range

of Object_Global failed.