Help with Compiling Excel Spreadsheet Data into One Table

**excelatlife** · 08-20-2012, 03:40 PM

Hi everyone, having trouble with one line of code. I think I'm pretty close to figuring out this macro. I'm getting the following error:
"Run-time error '438':
Object doesn't support this property or method"
on this line of code: wbMstr.wsMstr.Range("c1").End(xlDown).Offset(1, 0).Select

How can I better define my method? Thanks!

Please Login or Register  to view this content.

**Mordred** · 08-20-2012, 04:14 PM

Hi excelatlife, are you looking to copy/paste/transfer values from the csv to the master? If so, try:

Please Login or Register  to view this content.

By the way, please note my usage of code tags around my code. See the forum rules regarding how to apply them. Otherwise, one of the moderators will get you!

**watersev** · 08-20-2012, 04:44 PM

Originally Posted by excelatlife

Hi everyone, having trouble with one line of code. I think I'm pretty close to figuring out this macro. I'm getting the following error:
"Run-time error '438':
Object doesn't support this property or method"
on this line of code: wbMstr.wsMstr.Range("c1").End(xlDown).Offset(1, 0).Select

How can I better define my method? Thanks!

Hi excelatlife,

The cause of the error is that your C column is empty and instruction xlDown gets you to the very last row of the sheet and afterwards you want another row beyond the sheet limit - Excel starts screaming.

**Cutter** · 08-20-2012, 07:50 PM

@ excelatlife

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.