Need Help in finding the exact part of column in whole column using Macro

[Haidar123]

Please Login or Register  to view this content.

This code searches first 10 rows for the word Time in it and copies the whole column and paste it to another sheet named Sheet 1 ( Time column may start from the mid and it can have some other values above it)..What I want is that it should just start copying from Title "time" until the last entry of this column time and pastes it in another sheet ....
Need Modification Guys !!!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Haidar123]

Bro its not working!!!

For example in excel attached file there is a time column...above this column there are some values which i want to avoid...and want to copy only time portion to next sheet named Sheet 1

[JOHN H. DAVIS]

There was another character in the cell. Try:

Please Login or Register  to view this content.

[Haidar123]

You missed only one part...I Have solved it with your help Thanks
This is the code

Please Login or Register  to view this content.

[TMS]

Alternatively, try this:

Please Login or Register  to view this content.

Note that UsedRange can be unreliable and return a higher value than is current.


Regards, TMS

[Haidar123]

Thanks to All it solved My problem

[TMS]

You're welcome. Thanks for the rep.