Dynamic Range

Hi guys,

I am rather new to all of this and would appreciate some help.

I am trying to create a dynamic range, but just cant get it right:

I want to get the autofill feature for C column stop once it has reached the same number of row entries in column A.

********************************************************

Please Login or Register  to view this content.

**********************************************************

Can anyone help me please?

Thanks,

Matt

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time only, be sure to read the Rules.

Why not add the Dynamic range manually?

Do you want =TODAY() or a fixed date?

Maybe something like this:

Please Login or Register  to view this content.

Putting in =TODAY() into those cells will result in a date that will keep changing. If you want the date to stay the same the next time you open the sheet, change that last line of code to:

Please Login or Register  to view this content.

Hi Matt,

One way would be to create a variable to record the number of rows in column A. Assuming the column A values start in row 2 use something like

Please Login or Register  to view this content.

Then substitute

Please Login or Register  to view this content.

Incidentally, you don't need all the .Selects.　It:s more effcient just to address the ranges in question. e.g.

Please Login or Register  to view this content.

Untested since I only have access to Excel for Mac 2008 at the moment and in their infinite wisdom Microsoft are no longer supporting VBA with Excel!

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)