Run time error
This may be a repeat post but I have waited for about 20 minute and the
original has not showed up yet.. If it should be a duplicate please pardon
the repost.
My code s copying a range from all files in the folder. The sheets appear
to be the same yet on some sheets the code runs and on other I get a Run time
error 424 "Object Required" on the line.
rng.Copy Destination:=oSh.Cells(iRow, 2)
ANy ideas where I might start trouble shooting? I see no obvious
differences. Each file is created from a common file with only the file name
changing.
Thanks!
|