G
Guest
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
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