Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
URGENT: Mac/PC Macro compatibility problem | Excel Programming | |||
URGENT Mac/PC macro compatibility problem | Excel Discussion (Misc queries) | |||
Problem with Autofill Macro | Excel Programming | |||
Macro help urgent urgent | Excel Programming |