I have a marco having three buttons .The first button Load source file is reading four files from the local drive.When trying to do the Map Target functionality getting the bellow error.
"runtime error 1004 application-defined or object-defined error"
Do Until wb.Sheets("IC - Sales Forecast").Cells(10, coltemp).Value = ""
If wb.Sheets("IC - Sales Forecast").Cells(9, coltemp).Value <> "" And wb.Sheets("IC - Sales Forecast").Cells(10, coltemp).Value = "Sales forecast" Then
Do Until wb.Sheets("IC - Sales Forecast").Cells(myrowsource, 1).Value = ""
ThisWorkbook.Worksheets("Target").Cells(myrowtarget, 1).Value = wb.Sheets("IC - Sales Forecast").Range("C5").Value
The error is coming in the above line.
Regards
Jay