Formula AutoFill - Last Row with Abosolute Referencing

Hello all,
Can anyone help fix the code I am working on.

I have data that will not always contain the same number of rows. I want to autofill a formula to the column to the last row, this part I have done fine, however its the absolute reference I cant do.

This is the code:

Please Login or Register  to view this content.

When I run the Macro it works great, however as it currently ends up showing =RANK(C2,$C$2:$C$229) this will not work fine if there are more or less than 229 rows of data.

Thanks for any help.

Please post a sample workbook

Regards, TMS

And please, before I can continue, use Code Tags in your first post in this thread.


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 here



Post updated: thanks.

Thanks for updating the post.

I rarely use Autofill if I know the range that the formula is going to go into. And you don't need to select anything.

Please Login or Register  to view this content.

Regards, TMS

Thanks for the rep.