Runtime Error

[samarbac]

Hi,

I'm using the below code to copy and paste but due to the formula in cells i have to use .Find syntax there however I'm getting a Runtime error 91 - Object Variable or With Block variable not set

Please Login or Register  to view this content.

please can someone guide me.

thanks

[Trebor76]

Hi samarbac,

Are you trying the copy the entire column (say "K") or the last row in the column (say "K10")?

[Trebor76]

Your code will error out if there's no data in any of the columns you are trying to copy and paste. Also the syntax on some lines is incorrect (".Copy.Copy").

This will copy the entire column from Sheet1 to he required cell in Sheet2:

Please Login or Register  to view this content.