VBA code showing error "Run time error 424 object required"

[keshavtale]

in the attached file there is VBA code first i want to tell you that code i use to copy specific data from sheet 1 to sheet 2
i copy some data in sheet 2 for your example, i copied date then i copy value of cell D12, then i copied value of cell F11, then i copy value of cell W14,
then i copy another date then i copy cell value D30, then i copy value of cell F29, then i copy cell value of W32 and so on,
but now this code showing error , error is " Run time error 424 object required" please clear that error also i want copy another cell values
so do modification for that so also VBA code copy that values , i want to also copy cell values of cell C12,R12, then C30, R30
so please provide me solution, thanks

[torachan]

you are confusing your self with 'sheet2' and 'Sheet2'
one is the tab name the other is the sheet name.
look in the properties to sort which is which.
however your sheet format is a nightmare - you have concentrated to much on the 'pretty picture' and not the practicalities of data sorting.
there is also data deep in your sheet taking the rowcount to the extreme.
torachan

[keshavtale]

i also attached one another file in this file code is working fine but when i copy data from the file which is i attached previsouly then code could not run and show run time error

[torachan]

It falls-over because Sheet1 does not exist in your file - refer to my previous post - you are confusing sheet names with tab names.

Please Login or Register  to view this content.

[keshavtale]

ok i understand but i also want to copy data of cell C12, R12 and C30, R30 so please do necessary changes in that code

[torachan]

sorry, I will wait for someone else to pick this up.
your code does not make sense.
what purpose does reference to 'LastRow' serve, i cannot understand your logic.
torachan.

[keshavtale]

I did not write this code but can you provide totally different code