Return selected column index?

A

Alvin Bruney

Anybody out there know how to return the selected column index on a
spreadsheet?

ex, if I click on column B to select it, 2 should be returned. Or if B is
the closest you can get me, that will work as well
 
B

bwallan

lFirstSelectedClm = Excel1.Selection.Columns
(1).Column 'Physical row

lLastSelectedRow = Excel1.Selection.Columns
(Excel1.Selection.Columns.Count).Column 'Physical row

To perform same query for Rows swap 'Row' for 'Column' in
the above

BWA/ABKA
 

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

Insert Index into a Table 1
Extracting a cell value 2
Need Help with a VBA subroutine 0
Need Help with Macro Security 1
Automatic indexing in footnotes - solved 0
Paragraph numbering in Word 1
cell.address gives strange result 1
Setting language of a selected text in Office apps. 0

Top