Please help. I need a code to find the date and copy range and paste it somewhere.

[pedie]

Hi,

Once i enter date in range ("b2") in sheet2. I want a code to find the date in col b:b in sheet1, corresponding to date is table, if date is found i want the
code to select the date, select current region (which will be table), copy it and specialpaste it with all using source theme
in sheet2 range k12.
Thank you all for your help!

Thanks pedie!

 

[VoG]

If the code crashes after this line

Application.EnableEvents = False

then events will be disabled. Did it crash and if so what did you do before it crashed?

 

[pedie]

I don't know what i did..i just changed the range like the target value....etc

It was working fine then latter i changed my table again and it stops working again....
but i think i'll have to figure out what is wrong.....

Thank you sooo much VoG!
Pedie.