EXCEL VB COPY CELL FORMULA

All topics about coding, designing, etc. goes in here.
Post Reply
Mclaren
Registered User
Posts: 497
Joined: 30 Apr 2007, 02:00
Location: c:\program files\temp
Contact:

EXCEL VB COPY CELL FORMULA

Post by Mclaren »

I am trying to copy a formula from on cell to a selcted range. i get an error message though.
Runtime error 1004

Autofill method of Range class failed

my code :

Code: Select all

Selection.AutoFill Destination:=Range("L2:L" & intMyCount), Type:=xlFillDefault
    Range("L2:L" & intMyCount).Select

intMyCount is based on the number of records counted.

Any ideas ?
Post Reply