VBA problem with selection/copy specified range of cells

Hi Masters!

I am beginner at vba coding. I want to ask you for help.


At the beginning I want to create code which should select range of filled. Columns are constant (it should select from e.g. F column to I column, but number of rows are dependend on number of cells where until it will encounter e.g. "THEEND" string.
I had contrived about use resize() function, but it hasn't returned expected results.
Result should be like on image. It should select constant columns (F:I) and so many rows as it will encounter "THEEND".

Sorry for many mistakes, but I really on begin my adventure with VBA.

Attachment 495978
My code:
code.JPG
(Sorry for adding code in image, but security of forum block me because it claims that it should be sql injection, when i put code in brackets [ code ]

Hi,

There's no apparent reason why you can't upload the file. The paperclip attachment icon doesn't work so click the 'Go Advanced' on the right just below your post, then look underneath the post for the 'Manage Attachments' option.

When you've added the workbook we'll be able to check your code out.
The macro recorder is great for capturing code initially but it always needs tidying up. For one thing it always captures range addresses for that particular selection which is no good on another occasion. In addition you rarely need .Select and .Activate syntax. You can address objects directly without first selecting them

Your example code could be probably be simplified to:

Please Login or Register  to view this content.

Okay, I have uploaded it now.