Display question.

[Guest]

Right, seeing as i made a pigs ear of the first go, lets try again!

Is there anywhere in Excel which shows me how many cells i have
selected. I handle large amounts of data and it would be useful to see how
many cells are selected without using formulas etc.

thanks.

 

[Dave Peterson]

While you're selecting, you can watch the namebox (to the left of the formula
bar).

After you're done selecting, you can rightclick on the bottom right of the
statusbar (it looks embossed) and choose from a list.

Count, Count Numbers

But empty cells aren't included in those counts.

maybe a command entered in the immediate window of the VBE (where macros live)
would be sufficient:

hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window

type one of these and hit enter:

?selection.cells.count
?selection.address