02-27-2014, 09:09 AM
Did you closed the work book in your script? (Test1)- we have to close the any work books at the end of the script without fail otherwise you can access them in next script....
Use the UsedRange and get the row where you have enter the data rather hard coding the row numbers.
Use the UsedRange and get the row where you have enter the data rather hard coding the row numbers.
Thanks,
SUpputuri
SUpputuri