Go down range, then cut, offset, paste

[GeorgY]

Hi Guys,

I am trying to create a macro that goes down Column A of my sheet and looks for a string, "Number". When it finds it, it resize (0, 14) and cuts.

Then it pastes the array at an offset of (-1, 10) This is what I got so far:

Please Login or Register  to view this content.

Please advise..

[StephenR]

Try using Find. If you have more than one instance of "Number" this code will need adjusting.

Please Login or Register  to view this content.

[GeorgY]

Thanks for replying. My experience with the Find function is that it's pretty slow. I have about 2000 "Numbers" in column A and this will take a while. I am looking for a quicker way to do this...

[StephenR]

I think you'll find Find faster than a For-Next loop.

[GeorgY]

Thank you, works fine now.