Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO
A good day
Can somebody please to learn me if ADO can do an autofill method in a closed workbook ? ... .... to do in a closed workbook the same action like in VBA : Range("B91:B7000").Select Selection.AutoFill Destination:=Range("B91:BB7000"), Type:=xlFillDefault ???This is my first information that I need strongly ! 2.The second thing is to know if ADO can do ClearContents in a closed workbook like in VBA code : Sheets("1").Range("C91:BB22005").ClearContents, but with the workbook not open . Thank you very much ,any sugestion is very helpfull for me . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|