Find Extents of Data

  • Thread starter Thread starter Presspley
  • Start date Start date
P

Presspley

I believe that there is a simple function available in VBA that searches for
the extens of the data once a cell is highlighted. For example by clicking
in the centre of a large range of data, this command effectively then
returns the extents allowing easy definition of a range.
 
You must log in or register to reply here.

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

Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Find cursor position relative to extents of a picture 0
Return last row no. of column with blanks at top 7
Improvement to sub: Detect data extent and convert to values 5
How to limit number of Message Boxes on Validation Error? 2
Substituting substrings 3
I'm getting unwanted rounding to integer for an average of range of cells. 2

Back
Top