Excel Macros

L

LMI

How can i setup a range macro were if the user dumps 10 cells worth of data
it will select jsut those 10 cells however if the user dumps 20 cells it will
adjust the range to select all 20 cells.?
 
B

Bob Phillips

ACtivecell.CurrentRegion.Select

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

200KB versus 35MB 0
Need Help with Macro Security 1
Pasting a cell into bookmarked table from excel vba 1
Can I edit macro buttons on the quick access toolbar in excel? 0
Weekly Report 2
Excel does not accept text format! 0
Word macro that can call cells out of Excel for a find and replace 0
Paste to excel from word - auto format problem 1

Top