Macro to copy data -run Time Error

I have tried to write code to copy data from text "Assets" in Col A on sheet "Data Import" and two rows above up to "Total equity and liabilities" and 4 columns to the right i.e up to Col D on to sheet "Balance Sheet"


I get a run time error "Object variable or with block variable not set"


I have copied the data manually to show the final result


It would be appreciated if someone could kindly assist

Please Login or Register  to view this content.

It works perfectly for me. Check if you have made a typo in the name of any sheet.

Artik

It works now thanks

I closed down Excel and then opened file and it worked

I have run a run a macro first and when I tried to run this macro, I got a run time error. Not sure why after closing Excel and then running this macro this it suddenly would run with no run time error

Howardc1001,

Could be Find method.
Find method remember the settings, so if you/your other code change the one of the protocol, it applies.
And it will be setting back to default when you re-open.
Since "Assets" have carriage return, it should be xlPart,
try

Please Login or Register  to view this content.

Find method remember the settings, so if you/your other code change the one of the protocol, it applies.

Thanks for the explanation and code

Will try this and let you know

Works perfectly Jindon-Many thanks