Specify Range with Dynamic row/col

[daviddoria]

Of course you can make a Range like this

Please Login or Register  to view this content.

or like this

Please Login or Register  to view this content.

but how do you make a range that the user inputs without setting the active cell? ie set the row bounds and col bounds programmatically like

Please Login or Register  to view this content.

Is that possible?

Thanks,
Dave

[daviddoria]

ah sorry, so easy - just use the cells function

Please Login or Register  to view this content.

Is there a way to delete my own post in a case like this where I answer my own question?

Dave

[Leith Ross]

Hello daviddoria,

No need to delete the post, just marked it solved. I have already done it for this post.

Sincerely,
Leith Ross

[mikerickson]

You can also use the InputBox method

Please Login or Register  to view this content.