View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marika1981 marika1981 is offline
external usenet poster
 
Posts: 22
Default URGENT problem with Autofill in a macro

I wrote a macro which uses Autofill and End(xlDown) to fill in twenty or so
blank cells in a column before hitting text below. When I perform the macro
on my computer it works fine; however, on my client's computer, executing the
macro replaces the ENTIRE column of text, overwriting all data below rather
than just filling in blank cells until it hits text/data.

Specifically, the formula I'm using, (which should copy the contents of
E12:G12 down through a series of blank cells until it hits text) is:

Range("E12:G12").AutoFill Destination:=Range("E12", Range("G12").End(xlDown)
(0))

Any ideas what might cause this and how to fix?????

MANY, MANY, MANY THANKS,

Marika :)