Code to run to currently populated cells

Hi all

I am using the following code to insert two new columns and then put the weeknum and L2 in each, and then delete an unwanted cell, my question is that my data sped changes each week this week it had 198 next week it may only be 180 or 80 how do i change the code so it only goes as far as whats in cells C.
I am new to this and trying to learn as i go so any help would be good.

Thanks you.

Please Login or Register  to view this content.

Sorry Friend

I cannot help until you insert code tags.



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.

Click on Edit to open your thread, then 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

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

First lets tidy up your existing code.

Please Login or Register  to view this content.

Now lets modify it to find the last used row in column A, Column C when you insert 2 columns and only work to that row.

Please Login or Register  to view this content.

Sorry typo. just corrected it

Thanks thats solved it