Pls help me solve this problem.
Error : AutoFill method of Range class failed
Can you please show exception details from locals panel
Also two excels are there what are those? As the excel auto fill is in I but the required column is in D
The first case might be because there is only one row present
Cheers
@Anil_G
I think like you “The first case might be because there is only one row present”
So i can how solve this problem ? incase some time have only one, some time more one.
Use an if condition before auto fill range and if the dt.Rowcount>1 then auto fill else donot auto fill
Cheers