For...next and thisworkbook.sheets error

Hello i have a bit of complex code(at least fo me), what it does is, the user click on a button and then choose a file to open, with the opened file it looks for a number defined in the original workbook (sheets("dados")). Then copy that number and past it on the original workbook and the repeat this work for each value in cells b3:b23 on the sheet "dados".

Comments and msgbox are in portuguese.

Please Login or Register  to view this content.

The text as red is giving me a constant error. "application-defined or object-defined error"

can you guys help me?

ty, that worked for that part but now i got stuck in

Please Login or Register  to view this content.

With the error "method 'Range' of object '_global' failed

oh i see, i got it now :D

Im really sorry but one last thing,

i need it to loop through row 3 to row 23

Please Login or Register  to view this content.

.

Do i need to something else or you thing that good the way it is?

thank you :D