Using range in a macro from cell value

[ckserra]

Hi all.

I am currently running a macro that takes the top 25 lines from one tab and moves to another. Problem is, sometimes I need that 25 to be a smaller or greater number. Currently I am using:

Please Login or Register  to view this content.

And it works great. Can I use the cell value to change the "B25" above to read something like :

Please Login or Register  to view this content.

So it would pull the number from cell Q2 on the results tab and today for instance, it would pull the top 11 lines,

Thanks for the help!!

Chris

[alansidman]

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)

[ckserra]

Done! Thanks Alan!

[alansidman]

Try this

Please Login or Register  to view this content.

or more efficiently

Please Login or Register  to view this content.

[Olly]

Or simply:

Please Login or Register  to view this content.

[ckserra]

Ok. I missed an important piece of info. The tab that the X value it on is a different tab, named "Final".

[alansidman]

Please Login or Register  to view this content.

[Olly]

Then:

Please Login or Register  to view this content.

[ckserra]

Perfect!! Thanks for the help guys!!