ModifyVBA to fill to bottom of data

[Delta729]

So I figure out how to modify a recorded marco correctly as I have no real experience with vba.

I recorded a marco that fills a formula from row 2 thru 11 that looks like:

Please Login or Register  to view this content.

However, there is different amounts of data each time I get a new data set and it'd be great to fully automate this, however I can't figure out how to modify this to fill to the bottom.

Any help would be greatly appreciated.

Thanks

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



( I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[teylyn]

Hello,

try along these lines:

Please Login or Register  to view this content.