Click here to Skip to main content
15,868,141 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900