I'm not sure exactly what you need in the end (cells, multiple cells in a
row, the entire row, something else), but perhaps this non-VB procedure
might be of use (if you really need this in VB, the procedure can be coded).
Click Edit/Find on Excel's menu bar, click the "Options" button to display
the full options for the dialog box (unless the options are already
displayed, of course), leave the "Find what" field blank (empty, with
nothing in it) and click the Format button. Click the "Alignment" tab and
select "Left (Indent)" from the Horizontal drop down and put 12 in the
Indent field and then click the OK button. Now, click the "Find All" button
and then key in Ctrl+A.... doing this will select every cell on the
worksheet with that particular format.

--
Rick (MVP - Excel)


"dude_down_under_1" wrote in
message ...
Is there a way to get Excel to return the alignment settings of a cell ?
I
use the CELL function extensively but it only returns limited information.
I
have a spreadsheet provided by a client where I need to extract all rows
which are left aligned with an indent of 12, but I can't find a function
that
will return such information to me so that I can do this extract. Any
assistance would be appreciated.