object doesnt support this type of property or method

[roken86]

Hi Everyone,

i have used this VBA code before and it worked fine, but now i am getting the above error and cant figure out for the life of me why..or how to resolve it..

the line that is causing the issue is wbtarget.range (cell).select

Range isnt available in the drop down.

Does anyone have any ideas... just my luck i am using it first day of a new job and it is failing after working fine for 6 years previously..

ultimately, i am selecting a range form workbook A, Sheet A and pasting it in to workbook B range with same sheet name...

Please Login or Register  to view this content.

[TMS]

Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Given that you explicitly refer to workbooks and ranges, there is no need to activate workbooks or select ranges.

That said, Range is a Property of a Worksheet not a Workbook.

[Norie]

You don't actually need that line or any of the Activate stuff you have in the rest of the code.

PS When posting code can you please use CODE tags?

[roken86]

apologies, i have now amended the post... if i dont need to define the target range how will it paste the data?

[mohan.r1980]

try below code

Please Login or Register  to view this content.

[roken86]

Hi Mohan,

thanks, this is definitely a simplified route, however, the same line gives the same error. wbtarget.range

if i try to type it in manually, it doesnt seem to allow .range to follow wbtarget?

[roken86]

I Have managed to resolve this using the below..

Please Login or Register  to view this content.

[Norie]

Like I said, you don't need to Activate.

Please Login or Register  to view this content.

PS This is using K87 as the target range, is that not what you want?

Please Login or Register  to view this content.